Hi Shimi and Erez, On Wed, Mar 23, 2016 at 12:53 PM, shimi <[email protected]> wrote:
> > > 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 ? >> >> > 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) > > Subversion already uses xdelta (or its alternative vdelta) internally for keeping track of binary diffs, so this will likely not buy you much (and add a lot of complexity to the process). I believe git and mercurial/hg can handle binary diffs well in a similar manner. As a result, one cannot rely on the textual "diff -u" output to accurately indicate the change size (e.g: changing one byte in a line of thousands of bytes will yield a thousands-bytes diff -u , but be a very small binary change). Regards, — Shlomi Fish > -- Shimi > > [1] http://xdelta.org/ > > _______________________________________________ > Linux-il mailing list > [email protected] > http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il > > -- ------------------------------------------ Shlomi Fish http://www.shlomifish.org/ Chuck Norris helps the gods that help themselves. Please reply to list if it's a mailing list post - http://shlom.in/reply .
_______________________________________________ Linux-il mailing list [email protected] http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
