Point in time recovery question

MySQL & MariaDB Percona XtraBackup
1

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!

2

Hi prakash_bala;

Percona has a good guide for this, so I would start there:
[url]Percona XtraBackup

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

-Scott

3

Thanks a lot, Scott!