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


Digital Signage for displaying digital content

Digital Signage for displaying digital content

Digital signage is an innovative way to display dynamic digital content. For those of you who don’t know what it is, basically think of the screens that you have seen in retail stores and shopping centres that display advertisements. That is digital signage! Here’s an example: There are three main components that make up a […]

read more
LOOKING FOR SURVEY SOFTWARE?

LOOKING FOR SURVEY SOFTWARE?

If you’re looking for the best survey software available on the market then let me introduce to you WPForms. Yes, you will need WordPress to use WPForms. I’ve previously mentioned this tool in other articles listed below: HOW TO CREATE GREAT LANDING PAGES IN 2020 NEW SALESFORCE ADDON FOR WPFORMS Creating surveys is a great […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools