Description:
On Running `mysqlbackup` with --use-tts and --include option to backup all tables in a database, got following error.
200121 20:07:23 RDR1 ERROR: MySQL query 'FLUSH TABLES `sakila`.`FTS_0000000000000031_0000000000000045_INDEX_1`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_2`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_3`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_4`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_5`,`sakila`.`FTS_0000000000000031_0000000000000045_INDEX_6`,`sakila`.`FTS_0000000000000031_BEING_DELETED`,`sakila`.`FTS_0000000000000031_BEING_DELETED_CACHE`,`sakila`.`FTS_0000000000000031_CONFIG`,`sakila`.`FTS_0000000000000031_DELETED`,`sakila`.`FTS_0000000000000031_DELETED_CACHE`,`sakila`.`actor`,`sakila`.`address`,`sakila`.`category`,`sakila`.`city`,`sakila`.`country`,`sakila`.`customer`,`sakila`.`film`,`sakila`.`film_actor`,`sakila`.`film_category`,`sakila`.`film_text`,`sakila`.`inventory`,`sakila`.`language`,`sakila`.`payment`,`sakila`.`rental`,`sakila`.`staff`,`sakila`.`store` FOR EXPORT': 1146, Table 'sakila.FTS_0000000000000031_0000000000000045_INDEX_1' doesn't exist
Looks like the tool is trying to export based on the ibd files not based on the tables availables under a database.
How to repeat:
Run Mysql Enterprise backup on a server which has MySql provided standard Sakila database.
mysqlbackup --defaults-file="/etc/my.cnf" -u "root" -p'Commvault!12' --socket="/var/lib/mysql/mysql.sock" --backup-image="Sakila-0806" --backup-dir="/bhsbt/backup/Sakila-0806/full" --include="^sakila\." --use-tts backup-to-image