Re: Backing up MySQL tables
2003-04-02 16:34:14
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
|
|
|