Problem with innobackupex restore

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with innobackupex restore

    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...
    CentOS 5.8
    Kernel 2.6.18-308.13.1.el5
    MariaDB-server 5.5.25
    percona-xtrabackup 2.0.2

  • #2

    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.


    • #3
      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?