MySQL Forums
Forum List  »  InnoDB

Re: tablespace with that id or name does not exis
Posted by: Peter Brawley
Date: May 16, 2022 08:34AM

Try ...

1 Create a matching .frm file in another database directory, copy it to the database directory where the orphan table is

2 Issue DROP TABLE for the original table; InnoDB should comply and report that the .ibd is missing

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: tablespace with that id or name does not exis
98
May 16, 2022 08:34AM


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.