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

innobackupex unable to restore tables with FULLTEXT index

PBflexPBflex EntrantInactive User Role Beginner
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**
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.