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


REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

USB C cables are among the most ordinary accessories we own, yet they can make a surprisingly noticeable difference to how comfortable our devices are to use while charging. The Toocki USB C right angle cable is a good example of a simple accessory that tries to solve a very common irritation, because instead of […]

read more
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]

read more

Like our Page