I have several MySQL databases (differrent locations, different machines) which I currently backup mightly to central server via SSH and Mysqldump. The problem is, that these databases have gotten rather large and even using the mysqldump etc | gzip > somefiule.sql.gz, the transfer is taking about 3-4 hours on DSL lines. Is there a relatively simple way just to update the changes? Can I just rsync the binary storage files? Can i turn on replication just once a day? Can i use replication from Database1-TableA to BackupDatabase-TableB (instead of tableA) - All the remote database schemas are identical - contents are different.
Any comments or suggestions would be greatly appreciated.
