On Wed, Apr 02, 2003 at 12:27:34PM -0600, Alex Thurlow wrote: > I need to start backing up MySQL tables on one of my machines, but I've > heard that to you run the risk of table corruption if you just copy the > mysql directory while MySQL is running. Stopping the database is not an > option, and the only solution I've come up with is having another script do > a mysql dump and then backing up that. It seems like a waste of time and > resources to basically do 2 backups though. I was just wondering what > anyone here does for MySQL backups on their own systems?
Cron up mysqldump to happen just before the amanda run. Brandon D. Valentine -- Systems Administrator Center for Structural Biology Vanderbilt University