Thanks for the pointers Ryan, Ryan Novosielski wrote: > >> Are there any plans to give >> the client file daemons the ability to transfer just the differences >> instead of the whole file? >> > > This was a requested project, but I guess you can imagine what /I'm/ > going to say next. :) > > >> I guess one 'solution' would be to rsync the database to a local machine >> and back that up instead. >> > > Another thing you could do is back up a diff of the database (provided > this sort of thing actually works properly on SQL files -- I'm not > certain myself, but perhaps this idea can seed someone that knows what > they're doing) or something like that. Or, instead of backing up a > database dump, backing up logs that can be applied to the database? Just > throwing out some ideas. >
Database logs are like incremental dumps and they get rotated by default in MySQL. You're right in that they can be a lot smaller than an entire dump of the database but you'd need to do the occasional dump to simulate a full backup. Planning for disaster is difficult isn't it ;-) David. ------------------------------------------------------------------------- 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