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
510
May 16, 2022 08:34AM


Sorry, you can't reply to this topic. It has been closed.

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.