Re: revisioning mysql server

Evgeniy Ginzburg <[email protected]>
Newsgroups gmane.linux.region.israel
Message-ID <CALRpzn-jaru9KrK-bdG=6iyn3aKOLcHa-RTkzkRJtt86b1Bbaw@mail.gmail.com>
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 <[email protected]> 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
> [email protected]
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
>


-- 
So long, and thanks for all the fish.

_______________________________________________
Linux-il mailing list
[email protected]
http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.