Not the answer you need?
Register and ask your own question!

Restore not Working

T-OneT-One EntrantInactive User Role Beginner

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:

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.


  • noodlesnznoodlesnz Contributor Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.