Restore a backup on a remote server

MySQL & MariaDB Percona XtraBackup
1

Hi,

I am new Percona user,
I’ve managed to create a backup + prepare with innobackupex.
My question is if the restore can be done on a different server.
Just to clarify, I’ve made a successful backup + prepare on server X, now I want to restore it but on server Y (from server X), is it possible?
I’ve tried to run the following command:
innobackupex --copy-back /tmp/perconaBackup/2012-03-27_11-49-26/ --user=myuser–password=*** --remote-host=xx.x.x.xxx

But I received the following error message:

[B][CENTER]InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints “completed OK!”.

Original data directory is not empty! at /usr/bin/innobacku[/B]pex line 538.
[/CENTER]

Please advise, any help will be highly appreciated.

Thanks.

2

This means what it says. “Original data directory is not empty!”, this means the directory thast is your real data directory for the mysql server is not empty. You can only copy-back if the datadir is empty. So… clean it out by deleting or moving all files, and then do the copy back.

You can indeed restore on a different server. However, they need to be the same architecture for the most part, and the same version would be helpful as well. The backup is essentially a filesystem copy, so, that’s why.