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

To repair the database

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


USING WP MAIL SMTP TO RECEIVE EMAIL LOGS

USING WP MAIL SMTP TO RECEIVE EMAIL LOGS

Remember the good old days when you could just go to a website and see what all your email addresses were? Those days are gone, unfortunately. One of the biggest problems for businesses and individuals is spam. Spammers send out millions of emails a day, hoping to catch people who are not expecting to receive […]

read more
HIDE THE WEATHER AND NEWS WIDGET IN THE WINDOWS 10 TASKBAR

HIDE THE WEATHER AND NEWS WIDGET IN THE WINDOWS 10 TASKBAR

You may have seen the Weather and News widget appear on your Windows 10 taskbar after a recent update and today, I’m going to show you how to hide the Weather and News Widget. The Windows 10 taskbar is the central component of the Windows operating system that shows all the open programs and their […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools