i try to restore from a backup from saturday, i allready prepared the backup via:
innobackupex --use-memory=16G --apply-log /mnt/mysqlbackup/2014-10-11_18-05-35/
and then i used copy-back:
innobackupex --copy-back /mnt/mysqlbackup/2014-10-11_18-05-35
But it will stop with this error:
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources: http://www.percona.com/xb/p IMPORTANT: Please check that the copy-back run completes successfully. At the end of a successful copy-back run innobackupex prints "completed OK!". innobackupex: Error: Original InnoDB data directory '/var/lib/mysql/idbdata/' does not exist! at /usr/bin/innobackupex line 2141.
my Datadir is set to datadir=/var/lib/mysql in the config but i also have the innodb_data_home_dir set to /var/lib/mysql/idbdata/
So something is messed up here. Because if i create the innodb_data_home and try to restore i get an error that /var/lib/mysql/ is not empty.
innobackupex: Error: Original data directory '/var/lib/mysql' is not empty! at /usr/bin/innobackupex line 2162.
How can i get my database restored now?
thanks in advance.