Percona Xtrabackup prepare of backup with 3 tables errors

Discussion in 'Databases' started by asteraki1976, Dec 8, 2014.

  1. #1
    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
     
    asteraki1976, Dec 8, 2014 IP
  2. Nigel Lew

    Nigel Lew Notable Member

    Messages:
    4,642
    Likes Received:
    406
    Best Answers:
    21
    Trophy Points:
    295
    #2
    Nigel Lew, Dec 9, 2014 IP