[Linux] MySQL Incremental rsync

[Michael Marschall]

Yeah mysql replication would be perfect for something like this. 

Mike

--- Kwan Lowe <kwan@digitalhermit.com> wrote:

> 
> > I have an off site server with a dedicated ADSL link which I want to
> > rsync a nightly MySQL backup too.  The result of the mysqldump operation
> > is aprox 500mb, which takes way too long over this kind of link.  If I
> > follow this process, will rsync only submit the changes (i.e. new
> > additions to the db?)
> >
> > on MySQL Server perform a nightly:
> > rm -rf /var/backup
> > mysqldump to /var/backup
> > rsync /var/backup to remote box
> >
> > Or will rsync pickup the entire dump file again?  Obviously I wouldn't
> > be able to use gzip or bz2...
> >
> 
> This sounds like something that the binary log may handle. That way you don't
> have
> to dump the entire database, just send what has changed. There's also a few
> links
> online about replication and DR recovery that use the binary log so those may
> be a
> good start.
> -- 
> * The Digital Hermit   http://www.digitalhermit.com
> * Unix and Linux Solutions   kwan@digitalhermit.com
> _______________________________________________
> Linux mailing list
> Linux@flux.org
> http://www.flux.org/mailman/listinfo/linux
> 



       
____________________________________________________________________________________Sick sense of humor? Visit Yahoo! TV's 
Comedy with an Edge to see what's on, when. 
http://tv.yahoo.com/collections/222