Point in time recovery question

[prakash_bala]

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!

[scott.nemes]

Hi prakash_bala;

Percona has a good guide for this, so I would start there:
https://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/pit_recovery_ibk.html

If you want a deeper dive, you could also look in the MySQL manual:
http://dev.mysql.com/doc/refman/5.5/en/point-in-time-recovery.html

-Scott

[prakash_bala]

Thanks a lot, Scott!