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