How to Check and Repair MySQL Tables Using MySQLcheck
September 26, 2014 / by Marco / Categories : Technology, Wordpress
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
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.
OTHER ARTICLES YOU MAY LIKE
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
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
