we have been trying restore Percona (Partial + Incremental) mysql backup, but failing. The process followed is as below:
For Backup
# Step I: Take Partial-Full Backup
innobackupex --user=root --password=**** --databases="db1" /path/to/basebackupdir --no-timestamp
# Step II: Take Partial-Incremental Backup
innobackupex --incremental /path/to/incbackupdir --databases="db1" --incremental-basedir=/path/to/basebackupdir/ --user=root --password=**** --no-timestamp
For Restoration
Step I: apply log to full backup
innobackupex --apply-log --redo-only fullbackup
Step II: apply-log incremental backup
innobackupex --apply-log fullbackup --incremental-dir=/tmp/tmp_inc
Step III: Export Backup
innobackupex --apply-log --export fullbackup
Step IV: CREATE Required database in MySQL
mysql -uroot -p**** -e "DROP DATABASE IF EXISTS db1"
mysql -uroot -p**** -e "CREATE DATABASE db1"
Step V: Import DATABASE Structure
mysql -uroot -p**** db1 < db1.sql
Step VI: Discard tablespace
Step VII: Import table
cd /tmp/fullbackup/db1
cp -R *.ibd /var/lib/mysql/db1
cp -R *.cfg /var/lib/mysql/db1
Step VIII: Import tablespace
Step IX: restart mysql
service mysql restart
Restoration process works fine, Still we are failing, that One of the tables could not create the structure for FULLTEXT index(it gets corrupted), when we try to create table manually error is table already exists.
Please Help