{"id":6902,"date":"2017-01-13T17:35:57","date_gmt":"2017-01-13T06:35:57","guid":{"rendered":"https:\/\/www.businesslegions.com\/blog\/?p=6902"},"modified":"2017-01-13T17:35:57","modified_gmt":"2017-01-13T06:35:57","slug":"fix-corrupted-table-mysql-database","status":"publish","type":"post","link":"https:\/\/www.businesslegions.com\/blog\/2017\/01\/13\/fix-corrupted-table-mysql-database\/","title":{"rendered":"HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE"},"content":{"rendered":"

One of the websites I manage Digital Signage Blog<\/a> was not displaying correctly (posts were not displaying, menu was missing links to the categories and only displaying pages)\u00a0and 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<\/a>\u00a0and How to repair WordPress databases<\/a> but both instructions didn’t work.<\/p>\n

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.<\/p>\n

<\/p>\n

When I tried repairing that particular table using phpMyAdmin and it reported ‘Can’t create new tempfile:..’ and the ‘Operation failed’<\/p>\n

<\/p>\n

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<\/p>\n

cd \/var\/lib\/mysql\/[name_of_your_database]<\/pre>\n
Then use this command to fix it:<\/p>\n
myisamchk -r -f wp-term_taxonomy.MYI<\/pre>\n
This was the result, it fixed 3 indexes.<\/p>\n
\"myisamchk<\/p>\n
Here’s a video of how to do this:<\/p>\n