revisioning mysql server

[shimi]

On Wed, Mar 23, 2016 at 9:22 AM, Erez D <erez0001 at gmail.com> wrote:

> 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 ?
>
>
What about xdelta[1] and saving the .xdelta files ? (from last copy or
original copy - your choice, but the cost of choosing the former to save
space would be that you'll have to roll the opposite operation in sequence
for any recovery)

-- Shimi

[1] http://xdelta.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20160323/32b58326/attachment.html>