[GRLUG] Backing up MySQL

[L. V. Lammert]

At 03:23 PM 9/26/2011, you wrote:

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

Yes, it would be very interesting to see how you mange the backup, .. 
the DB we're trying to backup took 28 hours last time.

         Lee 


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