Re: better way to backup 50 Gig db?

[Shawn Green]

Mitchell Maltenfort wrote:
> I'm using MySQL to manage data on my computer .
> 
> The total data is 50 Gig in MyISAM folders.
> 
> As I type, I already have the folder with the myd, frm, etc being
> copied offsite.  As I understand it, if this computer dies tomorrow, I
> can reinstall MySQL on a new computer, drag over the archive, stick
> the folder under "data" and I'm back in business.
> 
> Or am I dreaming?
> 
> I'd rather be corrected now than find out the hard way.
> 
> Any advice?+
> 

Did you remember to FLUSH (with read lock) those tables before you 
started copying. Alternatively, you could have shutdown your MySQL 
instance, too.

If not, then the in-memory and on-disk images of your tables are out of 
sync. You may be copying away data that will appear corrupted after 
restoration.

-- 
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN