revisioning mysql server

[דותן שביט]

check mysqlbinlog 

# 

:כתב Erez D, 2016-03-23 09:22 בתאריך 

> 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
> Linux-il at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20160323/cc5a660c/attachment-0001.html>