I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12).
I have innodb_file_per_table set.
To create the backup, I'm running:
innobackupex --tables-file=tables.txt --no-timestamp /path/to/backup
Then I create the table exports:
innobackupex --tables-file=tables.txt --apply-log --export /path/to/backup
The --export run produces an error message for each of the fulltext index files ("FTS...") in my database directory:
InnoDB: Failed to find tablespace for table `webdb`.`FTS_00000000000005ce_0000000000000630_INDEX_1` in the cache...
Do I have to do the --export run right after I create the backup ? Or can I delay that until I actually need to restore a backup ?
What can I do about the error for the FTS files ? Is that normal ? Will Mysql re-create the fulltext index automatically or is it even included in the main tables .idb file ?
It would also help if someone could report that backing up tables with fulltext search using Xtravackup did or did not work with Mysql 5.7 for him. Then at least I would know if its a bug in the tool.