MySQL Forums
Forum List  »  InnoDB

Re: table space id
Posted by: Andrew Simkovsky
Date: August 30, 2013 09:31AM

Sounds like somebody removed the files from the file system before dropping it in the database, and the database thinks its still there.

The way to handle this would be to create a new table with the same structure as the previous table. It will probably error. Then run a drop table command for that table. That will error too, but should clean up the entry. Keep repeating this until it allows you to create then drop the table.

Sounds weird, but I've gotten this to work, as each time it attempts to create the table, it tries to put metadata in for that table, and either the table name overlaps with the old table, or the tablespace id overlaps with the old table, and forces MySQL to do something about it.

Andrew Simkovsky
More mysql forums (and other databases):
http://www.dbtekpro.com/forums
Brand new! Just post!

Options: ReplyQuote


Subject
Views
Written By
Posted
5816
August 27, 2013 08:43AM
Re: table space id
2213
August 30, 2013 09:31AM
1588
August 30, 2013 09:48AM
1526
August 30, 2013 09:48AM
1326
August 30, 2013 01:41PM


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.