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

Reply via email to