Backup restoration in different directory.


I’m making incremental backups using xtrabackup.
My problem is that I can’t find how do I have to do to perform the restoration.

I’d like to restore (prepare) my backup into a different directory where the backup is.
Else I think that when I apply my incremental backups will overwrite full backup information.

At the moment I’m copying full backup directory in a tmp one and then I prepare the incremental backups.
I have 31 GB of backup and to copy it is a long process.

As I understand, if I apply incremental backups over a full backup I’ll get the full backup after the incremental period. But I’ll lose my previous full backup, isn’t it?
I need to keep my full backup as it was before.

Anyone knows how could I prepare a incremental backup pointing a different directory?
I can’t find any information about it.
I’ve tried using different options as --datadir, --tmpdir even --targetdir (that I don’t rememeber where found it) but my tmp directory continues being empty.


Hello Marcos, have you read this following page for further information about the process?


I’ve seen this page, but maybe I don’t undetstand the working.

As I can see I could apply-log over BASE-DIR (that I understand is where the full backup is) and then I apply incremental logs over this BASE-DIR. Then I’ll have a “full backup” up to the time of the incremental one in BASE-DIR. As I see then I’ll had lost my first full backup, isn’t it?
I can’t lose the base full backup.

That I need is to be able to keep recovering information any moment of the past.
My incremental backup are done each two hours, and maybe I could need 12:00PM information and later to recover 8.00AM info.

I don’t know if is possible to do it by a easy way :confused:

Thanks again!


You need to make a copy of your full backup if you want to keep it. Copy it to a ‘staging’ area where you will apply incrementals to it and keep the original in some safe place.

George O. Lorch III
Software Engineer, Percona