Hi!
What version of MySQL are you using?
I want to check that you are not affected by this bug:
[URL=“http://MySQL Bugs: #45976: InnoDB lost files for temporary tables on graceful shutdown”]MySQL Bugs: #45976: InnoDB lost files for temporary tables on graceful shutdown
It is about /tmp but anyway, we should double check it.
Does the db_name directory exists? And the corresponding .frm file of that table?
If the .frm file exists:
- shutdown mysql
- remove the .frm
- start mysql