<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'>I've read in the high-performance mysql book that dumping / loading CSV
files are faster. But in general, backing up at the file-system level
is a lot quicker.<br>
<br>
If the DB resides on top of LVM, you can use the lv tools to make a
snapshot and copy the files from there. I can tar/gz a 40 GB DB in about two hours ( 5 x 15K RPM SCSI disks though).<br><br>We use replication slaves heavily, backing up the DB and the replication logs just in case we need to roll-back a big mistake! Makes restoring easy too - just untar over the old directory and start mysql - no need to setup a blank DB and bring in user permissions. Michael, I can send you my backup script if your interested.<br><br>Regards,<br>Scott<br><br><br><hr id="zwchr"><b>From: </b>"L. V. Lammert" <lvl@omnitec.net><br><b>To: </b>"Mailing List for LUG in greater Grand Rapids, MI area." <grlug@grlug.org><br><b>Sent: </b>Friday, September 23, 2011 5:39:42 PM<br><b>Subject: </b>Re: [GRLUG] Backing up MySQL<br><br>At 04:35 PM 9/23/2011, you wrote:<br><br>>My (vague, unsophisticated) understanding is that mysqlhotcopy makes a<br>>copy of the raw data files. I'll note that I don't know whether or not<br>>it even works with InnoDB.<br><br>That might be true, .. but the docs mention "files", which would seem <br>to indicate ISAM. In this case, the engine is InnoDB.<br><br>>mysqldump, on the other hand, outputs valid SQL which recreates the database.<br><br>Yes, .. but at least it gets the entire database (ISAM *OR* InnoDB).<br><br>>BTW, if you think mysqldump is running slow, wait until you try<br>>restoring that dump. At 33 hours or so for a backup, it might take you<br>>more than a week to restore, depending on the options you gave<br>>mysqldump for building the output.<br><br>No kidding!<br><br> Lee <br><br><br>-- <br>This message has been scanned for viruses and<br>dangerous content by MailScanner, and is<br>believed to be clean.<br><br>_______________________________________________<br>grlug mailing list<br>grlug@grlug.org<br>http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug<br></div><br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</body></html>