How do I stop MYSQL trying to load a missing InnoDB table?

Question

Everytime I start MySQL, I receive the error:

Cannot open datafile for read-only: '.\deleteddatabase\deletedtable.ibd' OS error: 103

I can't DROP the table, because it doesn't exist. There's no corresponding .frm file. I presume that somewhere in ibdata1 there's a reference to this old InnoDB file.

How do I stop the error?

• Barsigo Patoo: check this answer on stack dba.stackexchange.com/questions/54608/…

Answer 1

I fixed this by creating the missing database and table (with just one field), then dropping both the database and table.