How to Check and Repair MySQL Tables Using MySQLcheck
September 26, 2014 / by Marco / Categories : Technology, WordpressFor 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
BUGS IN TIKTOK WEB APP
In this article, I will discuss the bugs I have encountered while using the Tik Tok web app. When using the TikTok web app, I encountered a frustrating issue where I was unable to follow back users. This problem has persisted, leaving me with zero following despite my efforts to engage with the platform. As […]
read moreTHE BEST WOOCOMMERCE AFFILIATE AFFILIATE RETAILER PLUGIN FOR MAXIMUM PROFITS
In today’s highly competitive e-commerce landscape, leveraging the power of affiliate marketing has become a crucial strategy for online retailers to maximize their profits. And when it comes to running an efficient and lucrative affiliate program on your WooCommerce store, choosing the right plugin is paramount. The best WooCommerce affiliate retailer plugin that stands out […]
read more