Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql backup quesiton



 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 
> 


BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org