revisioning mysql server

[Efraim Flashner]

On Wed, 23 Mar 2016 09:22:06 +0200
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 ?

Is there a program like mysql-diff that will compare two dumps and spit out a diff file? Or is it possible to copy the incoming commands to the database and write them to a separate file and back that up with a weekly snapshot of the database?

-- 
Efraim Flashner   <efraim at flashner.co.il>   אפרים פלשנר
GPG key = A28B F40C 3E55 1372 662D  14F7 41AA E7DC CA3D 8351
Confidentiality cannot be guaranteed on emails sent or received unencrypted
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20160323/7f561bc2/attachment.sig>