mysql backup quesiton

[Mark Hertel]

On 1/3/08, Stephen Adler <adler at stephenadler.com> 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?


--Mark

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