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,
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!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.