Re: revisioning mysql server

Efraim Flashner <efraim-13Rj+LLFh/9S1MOuV/[email protected]> Wed, 23 Mar 2016 09:56:07 +0200

Newsgroups	gmane.linux.region.israel
Message-ID	<20160323095607.7bb0d0b5@debian-netbook>

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

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-13Rj+LLFh/9S1MOuV/[email protected]>   אפרים פלשנר
GPG key = A28B F40C 3E55 1372 662D  14F7 41AA E7DC CA3D 8351
Confidentiality cannot be guaranteed on emails sent or received unencrypted

_______________________________________________
Linux-il mailing list
[email protected]
http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il

signature.asc (application/pgp-signature, 819 B)