MySQL Forums
Forum List  »  InnoDB

tablespace with that id or name does not exis
Posted by: haitham mahd
Date: May 16, 2022 12:17AM

ERROR] InnoDB: Table recording/#sql2-469-f in the InnoDB data dictionary has tablespace id 116, 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.


how can i solve the above issue, please note that the .ibd anf .frm file are missing

Options: ReplyQuote


Subject
Views
Written By
Posted
tablespace with that id or name does not exis
415
May 16, 2022 12:17AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.