SVN as SQL backup?
Posted: Mon Aug 18, 2008 4:38 pm
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.
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.