From: Shawn Green
Date: April 19 2010 10:24pm
Subject: Re: better way to backup 50 Gig db?
List-Archive: http://lists.mysql.com/mysql/221308
Message-Id: <4BCCD809.9010401@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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