Date: 04/28/08 (MySQL Communtiy)    Keywords: mysql, database, sql, web

I'm working on setting a mirror copy of some websites. The part I'm not sure about the best way to handle things is the MySQL database (I have rsync for the files)

Currently, a script would run from the mirror to collect the MySQL data from the site with the live data (using SSH to run a mysqldump command, then SCP the dump file to itself) and overwrite the data on it's local copy.

I'm just wondering if there is something better (and no, I don't have root access at all. I only have access to some databases VIA the MySQL client)

Source: http://community.livejournal.com/mysql/128050.html