# Point-in-time recovery

**URL:** <https://forums.percona.com/t/point-in-time-recovery/5959>\
**Category:** Percona XtraBackup\
**Created:** [October 26, 2017, 6:18am UTC](https://forums.percona.com/t/point-in-time-recovery/5959 "2017-10-26T06:18:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ianbr](https://avatars.discourse-cdn.com/v4/letter/i/ebca7d/32.png) [@ianbr](https://forums.percona.com/u/ianbr)\
**Post date:** [October 26, 2017, 6:18am UTC](https://forums.percona.com/t/point-in-time-recovery/5959/1 "2017-10-26T06:18:24Z")

</div>

Hi all,

I have just upgraded to XtraBackup 2.4 and everything seems to be working well.  
I can do a full backup using xtrabackup --backup but am a little lost on how to do a point-in-time recovery.  
The documentation seems to say I need to have used the innobackupex program to do the backup but it also says that this program had been deprecated and that I should use the xtrabackup program so I am a little confused.  
Reading up on point-in-time recovery in the user manual it only refers to the innobackupex program.  
So if I shouldn’t be using this program, how do I do a point-in-time recovery?

I would really appreciate some help on this

Thanks in advance

Ian

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [October 27, 2017, 4:38am UTC](https://forums.percona.com/t/point-in-time-recovery/5959/2 "2017-10-27T04:38:51Z")

</div>

Hi Ian  
We posted a blog just this week, I wonder if this helps? [URL=“[MySQL Point in Time Recovery the Right Way - Percona Database Performance Blog](https://www.percona.com/blog/2017/10/23/mysql-point-in-time-recovery-right-way/)”][https://www.percona.com/blog/2017/10...ery-right-way/[/URL]](https://www.percona.com/blog/2017/10...ery-right-way/%5B/URL%5D)  
There are also some useful comments at the end of the post that point to other sources of information that are worthwhile reading.  
On your query about innobackupex - that command is deprecated but it still works so you could reliably follow the example to do a point-in-time-recovery .  
The xtrabackup documentation is currently being revised to fully document the xtrabackup commands.  
So thank you for highlighting this, and I will make sure that it’s on the list for update.

---

<div class="post-metadata">

**Author:** ![bugsbunny](https://avatars.discourse-cdn.com/v4/letter/b/4da419/32.png) [@bugsbunny](https://forums.percona.com/u/bugsbunny)\
**Post date:** [April 11, 2018, 12:34am UTC](https://forums.percona.com/t/point-in-time-recovery/5959/3 "2018-04-11T00:34:46Z")

</div>

Hi,  
The documentation explains the procedure to make a full backup followed by incremental backups and the restore section explains how to restore all the backups and --copy-back or --move-back them to the data directory.  
I understood that procedure, implemented it successfully (on test server) and recovered the database fully using the same method.  
But what I don’t understand is that,  
when it comes to innobackupex, can I use the backups (full and incremental) made by xtrabackup to make a point in time recovery using innobackupex or not? or do I have to make a separate backup for innobackupex and then copy the binary logs and then perform a Point in Time Recovery?  
I mean it’s bit confusing like ianbr mentioned.  
I am a new MySQL user and very new to Percona too. I have just downloaded the latest xtrabackup documentation 2.4.10 and I will go through it now for any updates on using the xtrabackup for PITR. Thanking you.