HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE

January 13, 2017   /   by Marco  / Categories :  Software, Technology, TIP AND TRICKS, Websites, wordpress
HOW TO FIX A CORRUPTED TABLE IN A MYSQL DATABASE

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.

myisamchk repair

Here’s a video of how to do this:

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


STOP NOISY CALLS: THE ANDROID SETTING YOU SHOULD SWITCH ON TODAY

STOP NOISY CALLS: THE ANDROID SETTING YOU SHOULD SWITCH ON TODAY

Phone calls still matter. Whether you’re speaking to a client, checking in with family, or handling something urgent on the move, clarity can make or break the conversation. If you’ve ever found yourself apologising for the construction noise behind you, the wind across your microphone, or the café chatter muddling your words, there’s an Android […]

read more
FILMORA 15 – WHAT’S NEW? AI EXTEND, DYNAMIC CAPTIONS, TRUE TIMELINE EDITING + INSTALL GUIDE

FILMORA 15 – WHAT’S NEW? AI EXTEND, DYNAMIC CAPTIONS, TRUE TIMELINE EDITING + INSTALL GUIDE

There is a particular thrill to installing a major new release of your everyday editor, especially when your workflow is comfortable and productive in the current version. That feeling is right at the heart of the move from Filmora 14 to Filmora 15. This upgrade promises fresh creative features, faster handling of complex projects, and […]

read more

Like our Page