[Box Backup] Using multiple servers
Martin Ebourne
boxbackup@fluffy.co.uk
Fri, 13 Jan 2006 11:54:41 +0000
On Fri, 2006-01-13 at 11:57 +0100, boxbackup@xolphin.nl wrote:
> For my MySQL database I use replication, and I make a daily export of
> all data with mysqldump. This dump is then being tarred and stored as a
> .tgz. Is this the recommended method or is it better to leave the .sql
> as it is, so BoxBackup can transfer only the changes of the export?
I leave my daily dump uncompressed. I've not tested it to see the
difference but suspect that makes more sense.
Box will compress it anyway before transmission. I can't remember if it
diffs before or after compression so it may or not make quite a bit of
difference.
Cheers,
Martin.