[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: rsync as a method to backup a database?

From: Blair Zajac <blair_at_orcaware.com>
Date: 2006-09-09 07:31:46 CEST

Jacob Jarvis wrote:
> For purposes of data backing up, is it adequate to just rsync the whole
> repository parent folder daily, or do I need to use the 'hot' or 'cold'
> methods for creating DB dumps then rsync'ing them?

No, the order of the files being backed up is important, so you just can't use
rsync unless you get the correct ordering.

However, somebody has already done all the work for you.

If you're on a filesystem that supports hardlinks and you're using FSFS, then
you can use svn-fast-backup, which uses rsync and a tree of hardlinks to older
backups, which makes for extremely fast backups:

http://svn.collab.net/repos/svn/trunk/contrib/server-side/svn-fast-backup

Regards,
Blair

-- 
Blair Zajac, Ph.D.
<blair@orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/svn/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Sat Sep 9 07:33:04 2006

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.