SVN as SQL backup?

Ideas, discussions about all topics - no matter how brilliant or stupid they are. Place for hobby-psychatrists, hobby-architects, hobby-scientists, hobby-whatever...
Post Reply
User avatar
^rooker
Site Admin
Posts: 1469
Joined: Fri Aug 29, 2003 8:39 pm

SVN as SQL backup?

Post 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.
Post Reply