Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am receiving an error when I am trying to restore from a percona backup to my local mysql server.
Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex line 2128.
sudo innobackupex --copy-back --force-non-empty-directories /home/fazlan/Desktop/2015-05-25_09-59-31/
I had also shut down the mysql service prior to executing this command using
sudo service mysql stop
How do I fix this error?
I am using Ubuntu 14.04.
You should be restoring to a completely empty folder - you need to remove all the content (files and folders) from the target folder before doing the restore. Xtrabackup contains the entire system, not just a particular database. As always, test the restore on your test environment before attempting on production! And remember to shut down MySQL before attempting the restore or cleaning the target folder...
