Re: 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
> [email protected]
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il

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