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
Our family has a Nintendo Switch with only the 2 Joycon controllers that came with the Switch. I decided to look at getting extra controllers but I noticed we had 2 PS3 controllers from the Sony Playstation 3. After some research, I discovered there are Bluetooth dongles that allow the PS3 controllers to connect to […]read more
I’ve started using the Google Captcha V3 on my websites and started noticing this badge appearing on the right-hand side of the website. The badge looks like this: I found this very annoying to look at so decided to find a way to remove it. The easiest way to remove it on WordPress is to […]read more