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


HOW TO GET FREE UPGRADE TO PERPLEXITY.AI PRO FOR 12 MONTHS AND TESTING PRO FEATURES

HOW TO GET FREE UPGRADE TO PERPLEXITY.AI PRO FOR 12 MONTHS AND TESTING PRO FEATURES

If you spend time researching, comparing, or synthesising information online, you have probably encountered Perplexity.ai — a research-focused assistant that blends large language models with live web search and citation trails. The Pro plan supercharges that experience with priority access to powerful models, higher usage limits, and premium capabilities baked directly into the interface. Right […]

read more
VidTechy: The Ultimate Tool for AI-Powered Video Optimization

VidTechy: The Ultimate Tool for AI-Powered Video Optimization

Unlock the potential of your videos with VidTechy, the ultimate AI-powered tool for seamless video optimization and enhanced viewer engagement.

read more

Like our Page