How to fix "InnoDB: Failed to find tablespace for table X in the cache. Attempting to load the tablespace with space"

Question

Mysql doesn't work, I get the following error:

[ERROR] InnoDB: Failed to find tablespace for table '"database"."table"' in the cache.
Attempting to load the tablespace with space id 1290.

Answer 1

I faced a similar issue today while copying a datadir from one server to another, the answer I m gonna post might not be a direct one. I have mistakenly added the innodb_force_recovery option in my configuration file thats the reason for the error, innodb_force_recovery value was set to 5. Post removing the innod_force_recover option I got rid of this issue.