tablespace with that id or name does not exist

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