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?

check this answer on stack https://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys — Barsigo Patoo, May 15 '18 at 07:19

score 1 · Accepted Answer · answered May 16 '18 at 14:44

1

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

answered May 16 '18 at 14:44

Mark Barnes

119
6

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

1 Answers1