1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

    Nigel Lew Notable Member

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