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 |
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 | |
We also thank MIT for the use of their facilities. |