<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'><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 6:13:28 PM<br><b>Subject: </b>Re: [GRLUG] Backing up MySQL<br><br>At 05:07 PM 9/23/2011, you wrote:<br>>>I've read in the high-performance mysql book that dumping / loading <br>>>CSV files are faster. But in general, backing up at the <br>>>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 <br>>>snapshot and copy the files from there. I can tar/gz a 40 GB DB in <br>>>about two hours ( 5 x 15K RPM SCSI disks though).<br><br>>Conicidentally, I just ran across mylvmbackup - seems to be a Perl <br>>script to do just what you describe:<br>><br>>http://www.lenzg.net/mylvmbackup/<br><br>That looks great. Under the sources section of the site, they have some links to some how-to's as well.<br><br><br>>>We use replication slaves heavily, backing up the DB and the <br>>>replication logs just in case we need to roll-back a big <br>>>mistake! Makes restoring easy too - just untar over the old <br>>>directory and start mysql - no need to setup a blank DB and bring in <br>>>user permissions. Michael, I can send you my backup script if <br>>>your interested.<br><br>>I would be very grateful, ..<br><br>> Thanks!<br>> Lee <br><br>My backup script is mostly geared towards handling replication during the backup process, and doesn't use LVM snapshots ( hence I addressed that offer to Michael, as he mentioned using replication). If your still interested though, I'll be happy to send over the script. Just no comments on my crude perl-scripting ability!<br><br>Regards,<br>Scott<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>