rsync as a method to backup a database?

[Jacob Jarvis <jj...@tatsumaki.net>]

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?

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

Re: rsync as a method to backup a database?

[Blair Zajac <bl...@orcaware.com>]

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.
<bl...@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