revisioning mysql server

revisioning mysql server

Evgeniy Ginzburg nad.oby at gmail.com
Wed Mar 23 09:39:19 IST 2016


You can try to switch to BUP https://bup.github.io/
This is GIT  based backup system, works fine in small scale scenarios.
It works OK with big files cause of chunk deduplication.


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 ?
>
>
>
>
>
> _______________________________________________
> Linux-il mailing list
> Linux-il at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
>


-- 
So long, and thanks for all the fish.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20160323/1cd36c32/attachment.html>


More information about the Linux-il mailing list