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.
Please advise, any help will be highly appreciated.