Best vcs to handle backup database

Question

At the moment, we are using git to backup our databases. I know there lots of reason to not do so, but this is not the topic of this post. We need to do it and we will do it (we have good reason for it). However, the problem is git doesn't handle large files really well and we can't push anything anymore because git run out of memory. I was wondering if any of git alternatives (hg, darcs ?) are better for this purpose.

Answer 1

You have conflicting requirements, you said that:

1. you have to use use to use git
2. git doesn't handle well large files

The second argument is true, every single change will reallocate the entire file.

You need a backup tool that handles efficiently diffs, what is against your first axiom.

Since you can't change #2, you have to loosen up #1 (or change git internals :) )

I would look for a backup solution specific to your database system. If none is up to your needs, go for a backup tool that uses rdiff algorithm (it hashes every 200 kB of the files, so small changes in large files only reallocate the blocks that changed).