Mysql incremental backup and point in time recovery

Question

I have a requirement for doing Incremental backup of MySQL database. For which I'm writing a shell script using the concept of binary logs.

Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be done in between. Suppose full-backup happens on Monday and Wednesday, incremental backup should happen on Tuesday. For point in time recovery, I'm using mysqlbinlog --starttime --stoptime binary-logs > backup.sql In the shell script I need to use starttime and log position of the previous full-backup to specify the log files in the statement, how can I retrieve this in a shell script and record the changes done during that time. Is there anyway I can do this, please help me in this regard.

Abhishek Anand Amralkar · Answer 1 · 2013-02-15T06:52:33.970

2

You can use Xtrabackup utility for mysql incremental backup they have shell script also you have to modify script according to your need.

edited Feb 15 '13 at 06:52

answered Feb 15 '13 at 06:41

Abhishek Anand Amralkar

1,979
12
16

I honestly can't recommend it enough to just learn xtrabackup vs writing it on your own – R. S. Feb 15 '13 at 06:42
I'm interested in a shell script, can anyone help me. – Rudra Feb 15 '13 at 07:07
From here you can check Shell Script https://gist.github.com/abhishekamralkar/4149641 – Abhishek Anand Amralkar Feb 15 '13 at 07:09

Mysql incremental backup and point in time recovery

1 Answers1