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

Problem with innobackupex restore

macktabmacktab EntrantInactive User Role Beginner
I create full backup:
innobackupex /backup-dir/
After I preparing my backup:
innobackupex --apply-log /backup-dir/2012-09-18_16-12-37/
And trying to restore it:
innobackupex --copy-back /backup-dir/2012-09-18_16-12-37/
But it says me:
Original data directory is not empty! at /usr/bin/innobackupex line 571.
Can somebody help me, please...
P.S.:
CentOS 5.8
Kernel 2.6.18-308.13.1.el5
MariaDB-server 5.5.25
percona-xtrabackup 2.0.2

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Original data dir means the dir from where you have taken a backup should be empty before restore the backup.
    So in this case you can do like
    i.e If your mysql data dir is /var/lib/mysql than you can follow below steps.

    sudo /etc/init.d/mysql stop
    sudo mv /var/lib/mysql /var/lib/mysql-old <--(You can use your datadir path here)
    sudo mkdir /var/lib/mysql
    sudo innobackupex --copy-back /backup-dir/2012-09-18_16-12-37/
    sudo chown -R mysql:mysql /var/lib/mysql
    sudo /etc/init.c/mysql start

    Please try with above steps and let me know if you still face the issue.
  • macktabmacktab Entrant Inactive User Role Beginner
    I just thought, that I can restore databases without stopping mysql and recycling datadir... If it is necessary, then everything is works right (I have already tryied to do this, just rm -rvf /var/lib/mysql/* ). Forum admins, can you or I remove this topic?
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.