Hi all...

I want to be able to backup my mysql server to a local machine using rsync/ssh. While there are many tutorials on how to do this, my concern is more of data corruption.

1. Will using rsync on a LIVE mysql server affect the LIVE server files at all? (I don't care if the backup version does not have the latest mysql entries and is a little out of sync).

2. Will the backed up database be stable? (if for instance both rsync and mysql are using the same file at the same time...not even sure if this can happen at the OS level)

thx for any illumination on this topic...