Re: mysql backup quesiton

["Matt Shields-5" <user=70@nabble.blu.org>]

 On Jan 3, 2008 9:43 AM, Matthew Gillen <[hidden email]> wrote: 
> Mark Hertel wrote: 
> > On 1/3/08, Stephen Adler <[hidden email]> wrote: 
> >> Guys, 
> >> 
> >> I need to backup my mysql database. Doing the 5min google search on the 
> >> topic, it looks like mysqldump is the tool of choice. The bit which I 
> >> don't like about mysqldump, is that it generates an ascii .sql script 
> >> which if invoked on a fresh mysql database, will recreate the database. 
> >> This seems a bit like a sledge hammer aproach. Are there any database 
> >> synchoronization tools or database mirroring tools which will do an 
> >> rsync like operation between databases? The backup scheme I have for my 
> >> subversion repositories is using svnsync which I like, since it 
> >> basically keeps two copies of the repository around, one a mirror of the 
> >> other. The same for a database would be great, and thus ever 24 hours, I 
> >> would only have to update the new content in the database, instead of 
> >> dump out everything into an ascii file... 
> >> 
> >> Thanks for your comments on this topic in advance. 
> >> 
> > 
> > 
> > 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). 
> 
> Matt 
>