Question

How to solve MYSQL "Table doesn't exist" even it does exist.

After we reboot the server, we can’t access the mysql database and it’s table anymore. The error is "#1146 Table ‘Table_name’ doesn’t exist. It is still there but we can’t open,


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hello,

You could try a few things here:

  • First try to restart your MySQL server – If the error has happened due to improper server shut down or MySQL service related errors, we restart the service and check if it fixes the issue. If the service doesn’t start properly, we further investigate and fix the error.

  • Try to Repair the tables:

repair table Table_name;
  • Try restoring a backup of your database

If none of those helps, then you would need to look into copying your ibdata file from a backup or enabling InnoDB crash recovery. Though before starting with those make sure to have a good backup of all of your databases.

Hope that this helps! Regards, Bobby