Live DB backups with rsync?

Jan-Benedict Glaw jbglaw at
Tue Jan 14 19:59:17 EST 2003

On Tue, 2003-01-14 15:44:26 -0400, Steve Mallett <spaceman at>
wrote in message <96CCDE1A-27F8-11D7-AAAB-000393D8DD4A at>:
> Is it possible to do live backups of a running DB with rsync???
> I was just talking to & they (only on win boxes) say they 
> can grab changes from a client's live DB & sync them remotely.
> It sounded like BS to me, but I'm neither a DB guy or sync'ing expert.

I think that's BS (or to name it for non-natice english speakers: bull
shit:-). Even if you had somethink like LVM to take a snapshot, the
database will be in some inconsistent state. There are only two (well,
three) sane ways of backing up a DB:

	- Shutdown, then take a backup (or take a LVM snapshot and
	  restart immediately afterwards).
	- Use some backup functionality the database server itself
	- Use a combination of both - some DB servers are IIRC capable
	  of not touching some primary DB files/storage areas for some
	  time but collecting any changes outside


   Jan-Benedict Glaw       jbglaw at    . +49-172-7608481
   "Eine Freie Meinung in  einem Freien Kopf    | Gegen Zensur
    fuer einen Freien Staat voll Freier Bürger" | im Internet!
   Shell Script APT-Proxy:
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url :

More information about the rsync mailing list