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]

mysql backup quesiton


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. 

Cheers. Steve. 

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

Discuss mailing list 
[hidden email]

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 /