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
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.
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?