Restore not Working

MySQL & MariaDB Percona XtraBackup
1

Hi,

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.

2

You can try changing your innodb_data_home_dir outside of /var/lib/mysql temporarily while you do the restore. You can always move this back into /var/lib/mysql after innobackupex has finished.