On Wed, 23 Mar 2016 09:22:06 +0200 Erez D <erez0...@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 <efr...@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
pgpfni4gYy8N0.pgp
Description: OpenPGP digital signature
_______________________________________________ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
