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
USE FUSEBASE TO AUTOMATE TEAMWORK AND COLLABORATION
If your business is growing, your team is juggling too many moving parts, and your client communication is spread across email threads, chat apps, documents, task boards, and endless follow ups, there is a good chance the real problem is not effort but fragmentation. Most businesses do not lose time because people are lazy. They […]
read more
USING REAP FOR VIDEO CLIPS
Short form video is now one of the most effective ways to reach new audiences, grow brand awareness, and turn long form content into a steady stream of social media assets. For creators, marketers, consultants, educators, and business owners, the challenge is rarely a lack of content. The real problem is time. Editing long videos […]
read more

