Subject: Re: Backing up MySQL
From: Joshua J.Kugler (isd@as.uaf.edu)
Date: Mon Mar 04 2002 - 13:34:20 AKST
Also make sure you do a READ LOCK on the tables before you simply zip the
files, or you might end up with files in a inconsistent state. That's why I
always do mysqldump. That way I don't have to worry about that stuff. :)
j----- k-----
On Monday 04 March 2002 12:08, Christopher S. Swingley wrote:
> Mike,
>
> > Besides using the mysqldump program, what methods are folks using to
> > backup their MySQL databases?
>
> I've tarred and gzipped /var/lib/mysql/dbname. I use this method to
> keep two databases in sync and it's much faster than the mysqldump
> method because restoring from a dump requires rebuilding the indexes
> (depending on the nature of your indexes -- this particular database
> has a FULLTEXT index, which takes a lot of CPU to regenerate).
> Of course, the backup file is probably larger with a tar file because
> you're backing up the indexes. So it's yet another speed vs. data
> size trade-off.
>
> Chris
-- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks isd@asuaf.org, 907-474-7601
This archive was generated by hypermail 2a23 : Mon Mar 04 2002 - 13:39:34 AKST