How to Check and Repair MySQL Tables Using MySQLcheck

September 26, 2014   /   by Marco  / Categories :  Technology, Wordpress
How to Check and Repair MySQL Tables Using MySQLcheck

For some reason my WordPress site was not displaying the correct information. The site uses WooCommerce and the products was not displaying at all. This was quite strange.

I thought I’d better backup the database so when I did, I received the following error message:

mysqldump: Got error: 145: Table ‘./xxx/wp_postmeta’ is marked as crashed and should be repaired

How to Check and Repair MySQL Tables Using MySQLcheck

This got me a little worried. So after some researching I had to check and repair MySQL database and tables.

The commands I had to use were:

To check the database

# mysqlcheck -c [database_name] -u root -p

To repair the database

# mysqlcheck -r [database_name] -u root -p

After running the repair, the problem was fixed.

RESOURCES
To display the databases use the command show databases; 
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