Re: revisioning mysql server

2016-03-23 Thread Shlomi Fish
Hi Shimi and Erez, On Wed, Mar 23, 2016 at 12:53 PM, shimi wrote: > > > On Wed, Mar 23, 2016 at 9:22 AM, Erez D 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

Re: revisioning mysql server

2016-03-23 Thread shimi
On Wed, Mar 23, 2016 at 9:22 AM, Erez D 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 change

Re: revisioning mysql server

2016-03-23 Thread דותן שביט
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

Re: revisioning mysql server

2016-03-23 Thread Efraim Flashner
On Wed, 23 Mar 2016 09:22:06 +0200 Erez D 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 chan

Re: revisioning mysql server

2016-03-23 Thread Evgeniy Ginzburg
You can try to switch to BUP https://bup.github.io/ This is GIT based backup system, works fine in small scale scenarios. It works OK with big files cause of chunk deduplication. On Wed, Mar 23, 2016 at 9:22 AM, Erez D wrote: > hi > > i have a running mysql server, and want to be able to resto

revisioning mysql server

2016-03-23 Thread Erez D
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