Point in time recovery question

I am new to MySQL and innobackupex.

Took a base backup at time T0, made some changes and then took an incremental backup at time T1 and made some more changes and took another incremental backup at time T2.

I am able to restore to various times (T0, T1 and T2) and validate the changes.

Now I have some more changes after time T2 which exists only in the ib_logfile*. What additional commands I need to run after “innobackupex --copy-back /data2/mysql/full” so that I can see the latest changes after a restore?

Tried copying the ib_logfile* to a different destination before wiping out /var/lib/mysql, ran the above command and restored these files before starting mysql. But it did not work.

Thanks in advance!

Hi prakash_bala;

Percona has a good guide for this, so I would start there:

If you want a deeper dive, you could also look in the MySQL manual:


Thanks a lot, Scott!