Hi When i try to prepare my backup (InnoDB tables) using Xtrabackup i got 3 errors: InnoDB: Table mysql/gtid_slave_pos in the InnoDB data dictionary has tablespace id 3, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary. InnoDB: It will be removed from the data dictionary. InnoDB: Table mysql/innodb_index_stats in the InnoDB data dictionary has tablespace id 2, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary. InnoDB: It will be removed from the data dictionary. InnoDB: Table mysql/innodb_table_stats in the InnoDB data dictionary has tablespace id 1, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary. InnoDB: It will be removed from the data dictionary. Why and how can i fix this? Is my backup now broken? Thanks
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html possible solution for that at the very bottom of that page. Or check this http://mysqlhints.blogspot.com/2008/10/fixing-innodb-import-tablespace-error.html at a glance you have mismatched ID's but I am not sure how to tell you how to resolve that. I dont have to lock tables very often during an export so I just use phpmyadmin. N.