Re: mysql backup quesiton

["Matthew Gillen" <user=50@nabble.blu.org>]

 Matt Shields wrote: 
> On Jan 3, 2008 9:43 AM, Matthew Gillen <[hidden email]> wrote: 
>>> Can't you just use rsync on the MySQL data directories to create a mirror? 
>> 
>> Only if you shut down the server first, to guarantee that you're not in the 
>> middle of operation that would leave the on-disk database in an inconsistent 
>> state (and thus unusable as a backup). 
> 
> Yes you can.  Do a flush tables, then do a LVM snapshot.  You can then 
> copy the files.  Once the file copy is done, release the snapshot.  I 
> use this method to refresh my replicated slaves if something gets 
> corrupted on them.  Master db stays online the whole time.