how safe is it to rsync databases?

Christoph Biedl cbiedl at
Fri Apr 14 16:49:53 GMT 2006

Julian Pace Ross wrote...

> I'm interested to hear feedback on this, since I was intending to backup a
> mySQL database 'on the fly' daily...

If you can afford to shutdown mysqld during the backup, rsync is not a
problem. I do a daily mysqldump(*) and backup these dump files only.
A completely different approach was to use the "slave" feature of mysql
for replication. Details are beyond the scope of this list but can be
found in the documentation.


(*) ToDo: Check whether mysqldump is actually an atomic operation.

More information about the rsync mailing list