On 8/1/07, Rich <[EMAIL PROTECTED]> wrote: > On 2007.08.01. 15:33, Dimitrios wrote: > > On Wed, 01 Aug 2007 15:20:50 +0300 Rich <[EMAIL PROTECTED]> wrote: > > > >> i still prefer dumps, they are more portable, easier to restore and > >> compress better. > > > > but what about incremental backups? as far as i know, you'd have to backup > > the entire database over and over again and for a very large database its > > something we'd like to avoid. > > yes, that would be problematic. maybe some hackish method of taking diff > from two dumps would work, but that would require even more diskspace on > the client. > > if you really need incremental backups, i don't know of any other method > than using binlogs > -- > Rich >
Yes, in order to do incrementals, you'll need binlogs enabled and you'll need to back these up. But also consider they take or can take a huge amount of space, so log rotating is necessary along with a possible performance hit as well, depending on the database demands, types of transactions, etc, going on. Probably one of the better tools I've seen is mysql-zrm from zmanda.com to help manage these types of backups for MySQL. -drew ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
