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
FILMORA 15.2.3 UPDATE: DID IT FIX PLAYBACK JITTER? A PRACTICAL TEST WITH GPU SETTINGS
Wondershare Filmora has received a new point release, and for many editors the first question is simple. Has this update finally fixed that annoying playback jitter in the preview window. If you have felt a stutter during editing that makes your footage look as if frames are being skipped or shuffled rather than played smoothly, […]
read more
STOP NOISY CALLS: THE ANDROID SETTING YOU SHOULD SWITCH ON TODAY
Phone calls still matter. Whether you’re speaking to a client, checking in with family, or handling something urgent on the move, clarity can make or break the conversation. If you’ve ever found yourself apologising for the construction noise behind you, the wind across your microphone, or the café chatter muddling your words, there’s an Android […]
read more
