Reply to Message

About 45 minutes ago.
I don't use mysqldump though.
Straight copy of the files, zipped up and dumped to mirrored raid set and a non raid drive. Goes every day and to dvd once a week.
This is on a slave server in a replication set. Entire operation is perl scripted, logged and cron'd.
Another cron job, checks on the replication and reads in the log file and checks to see if it's up to date. Emails supervisor group on failure, and also on success for the dvd. Even reminds me to change it and knows when I haven't.
Going to have to play about a bit more when the dbs go over 4Gig zipped up.