revisioning mysql server

[Erez D]

hi

i have a running mysql server, and want to be able to restore it to any
day, with as little backup space as needed

i do mysqldump to the same file every day then commit the file with "svn ci"
the idea is that if there are no changes, it takes no space

it works well if i just append entries to a database, as svn will just save
the changes

however, if i insert a record, and for instance the dump file has 5 record
at every line
then the change is big and actually svn will save most of the file though
there is a very small change actually.

another issue - if the records hold changing info like timestamps etc.

any idea ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20160323/8f2685ff/attachment.html>