Skip to main content

Solution

However, the easier option is this: restart mysqlMySQL, then do the same four steps listed near the beginning of the post.as follows:

1) created a dummy table in the database; 2) discarded its tablespace; 3) moved the .ibd file into the database folder on the system; 4) attached the tablespace back to the table 

This way, the tablespace id on the data dictionary and the file matched; thus importing the tablespace succeeded.

This can give you greater confidence in dealing with some of the InnoDB "gotcha's" during the recovery process or even file transfers.

ref

Solution

However, the easier option is this: restart mysql, then do the same four steps listed near the beginning of the post. This way, the tablespace id on the data dictionary and the file matched; thus importing the tablespace succeeded.

This can give you greater confidence in dealing with some of the InnoDB "gotcha's" during the recovery process or even file transfers.

ref

Solution

However, the easier option is this: restart MySQL, then do the same four steps as follows:

1) created a dummy table in the database; 2) discarded its tablespace; 3) moved the .ibd file into the database folder on the system; 4) attached the tablespace back to the table 

This way, the tablespace id on the data dictionary and the file matched; thus importing the tablespace succeeded.

This can give you greater confidence in dealing with some of the InnoDB "gotcha's" during the recovery process or even file transfers.

ref

Source Link
Bhavin Rana
  • 1.6k
  • 4
  • 22
  • 40

Solution

However, the easier option is this: restart mysql, then do the same four steps listed near the beginning of the post. This way, the tablespace id on the data dictionary and the file matched; thus importing the tablespace succeeded.

This can give you greater confidence in dealing with some of the InnoDB "gotcha's" during the recovery process or even file transfers.

ref