# Point in time recovery question

**URL:** <https://forums.percona.com/t/point-in-time-recovery-question/4498>\
**Category:** Percona XtraBackup\
**Created:** [November 5, 2015, 7:05pm UTC](https://forums.percona.com/t/point-in-time-recovery-question/4498 "2015-11-05T19:05:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![prakash\_bala](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@prakash\_bala](https://forums.percona.com/u/prakash_bala)\
**Post date:** [November 5, 2015, 7:05pm UTC](https://forums.percona.com/t/point-in-time-recovery-question/4498/1 "2015-11-05T19:05:19Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [November 5, 2015, 7:10pm UTC](https://forums.percona.com/t/point-in-time-recovery-question/4498/2 "2015-11-05T19:10:08Z")

</div>

Hi prakash\_bala;

Percona has a good guide for this, so I would start there:  
[url][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.2/innobackupex/pit_recovery_ibk.html%5B/url%5D)

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]](http://dev.mysql.com/doc/refman/5.5/en/point-in-time-recovery.html%5B/url%5D)

-Scott

---

<div class="post-metadata">

**Author:** ![prakash\_bala](https://avatars.discourse-cdn.com/v4/letter/p/c37758/32.png) [@prakash\_bala](https://forums.percona.com/u/prakash_bala)\
**Post date:** [November 5, 2015, 10:48pm UTC](https://forums.percona.com/t/point-in-time-recovery-question/4498/3 "2015-11-05T22:48:06Z")

</div>

Thanks a lot, Scott!