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
POWERFUL REFERRAL PROGRAM TOOL
Businesses of all sizes are constantly seeking new and innovative ways to grow their customer base and increase brand awareness. With the rise of social media and the reliance on word-of-mouth marketing, referral programs have become an essential tool for companies looking to expand their reach. However, managing a successful referral program can be a […]
read moreCYBER SECURITY PLATFORM FOR YOUR BUSINESS
Cyber security has become a top priority for individuals and organizations alike. With the ever-evolving threat of cyber attacks, it is imperative to have a strong and reliable security platform in place to protect sensitive information and data. That’s where Bleach Cyber comes in. As a leading cyber security platform, Bleach Cyber is dedicated to […]
read more