HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE
January 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
cd /var/lib/mysql/[name_of_your_database]
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:
Our Sponsors
- Advertise Me Pty Ltd
Digital Signage Solutions
OTHER ARTICLES YOU MAY LIKE
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY
If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]
read more
USE FUSEBASE TO AUTOMATE TEAMWORK AND COLLABORATION
If your business is growing, your team is juggling too many moving parts, and your client communication is spread across email threads, chat apps, documents, task boards, and endless follow ups, there is a good chance the real problem is not effort but fragmentation. Most businesses do not lose time because people are lazy. They […]
read more


