HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASEJanuary 13, 2017 / by Marco / Categories : Software, Technology, TIP AND TRICKS, Websites, wordpress
One of the websites I manage Digital Signage Blog was not displaying correctly (posts were not displaying, menu was missing links to the categories and only displaying pages) and after some investigation, I discovered one of the database tables (the categories table – wp_term_taxonomy) was corrupted. I attempted to repair the database by using these instructions How to check and repair MySQL tables using MySQLcheck and How to repair WordPress databases but both instructions didn’t work.
When I ran the repairs using the above methods there were no errors being reported that the database was corrupted. The only way I figured out that one of the tables was actually corrupted was to login to phpMyAdmin and saw the status of the table being in use.
When I tried repairing that particular table using phpMyAdmin and it reported ‘Can’t create new tempfile:..’ and the ‘Operation failed’
So to fix this I had to login to my VPS and use the SSH terminal to issue the following commands. Firstly go to the database files
Then use this command to fix it:
myisamchk -r -f wp-term_taxonomy.MYI
This was the result, it fixed 3 indexes.
Here’s a video of how to do this:
- Advertise Me Pty Ltd
Digital Signage Solutions
Limit to 5 sponsors.
OTHER ARTICLES YOU MAY LIKE
We previously talked about WPForm in this article: HOW TO CREATE GREAT LANDING PAGES IN 2020 If you’re using WPForms and also Salesforce you’re in luck. There is now a new addon which will allow you to automatically send form entries from WPForms to Salesforce CRM. Now you won’t have to manually export the data […]read more
Did you know about the Android 11 Easter Egg? Google just released Android 11 and they have a cool Easter egg called Neko Cat game. Check out this video on how to enable the Android 11 Easter Egg and if you need more detailed instructions read this article CAT LOVERS WILL LOVE THE ANDROID 11 […]read more