Page 1 of 1

SVN as SQL backup?

Posted: Mon Aug 18, 2008 4:38 pm
by ^rooker
Every time I see our daily database backup, I'm wondering how to improve the size requirements without too much hazzle.

When backing up a remote machine, it's better *not* to zip the .sql dump before transfer, so rsync can transmit a nice delta only, but then?

So, what about commiting the daily sql dump into a version control system that can handle deltas?

SQL is just text, so it could be handled perfectly!

Addtional bonus could be the easy backup-copy-distribution, by checking out the most recent copy on other machines, thus creating a redundant backup.