List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:April 19 2010 10:24pm
Subject:Re: better way to backup 50 Gig db?
View as plain text  
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
Thread
better way to backup 50 Gig db?Mitchell Maltenfort19 Apr
  • Re: better way to backup 50 Gig db?Shawn Green20 Apr
    • RE: better way to backup 50 Gig db?Gavin Towey20 Apr
      • Re: better way to backup 50 Gig db?Jay Ess20 Apr
        • RE: better way to backup 50 Gig db?andrew.2.moore20 Apr
          • RE: better way to backup 50 Gig db?Gavin Towey20 Apr
            • Re: better way to backup 50 Gig db?Rob Wultsch20 Apr
            • Re: better way to backup 50 Gig db?Claudio Nanni20 Apr
              • RE: better way to backup 50 Gig db?Gavin Towey21 Apr
Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
  • Re: better way to backup 50 Gig db?Johan De Meersman21 Apr
    • Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
      • Re: better way to backup 50 Gig db?Johan De Meersman21 Apr
        • Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
      • RE: better way to backup 50 Gig db?Gavin Towey21 Apr
  • RE: better way to backup 50 Gig db?Jerry Schwartz21 Apr
Re: better way to backup 50 Gig db?Claudio Nanni21 Apr