we have been trying restore Percona (Partial + Incremental) mysql backup, but failing to recreate FULLTEXT index for one of the tables. The process followed is as below:
For Backup
Step I: Take Partial-Full Backup (db1 out of many dbs)
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