[GRLUG] Backing up MySQL

[L. V. Lammert]

At 05:07 PM 9/23/2011, you wrote:
>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.
>
>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).

Conicidentally, I just ran across mylvmbackup - seems to be a Perl 
script to do just what you describe:

http://www.lenzg.net/mylvmbackup/

>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.

I would be very grateful, ..

         Thanks!

         Lee 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.