Fix: WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
For the first time this weekend I ran into a rather common Wordpress error: WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]. I also noticed this morning that Matt Cutts is having the same issue. It may seem scary, however, it’s really simple to fix.
To do so, just log into your MySQL database admin area. More than likely that’s done though your webstie’s control panel and phpMyAdmin.
Once in there, locate your blog’s database and bring up the main screen. The main screen is the one that shows you the listing of all the tables. Locate the the wp_comments table in the list and select the checkbox next to it. At the bottom of that page there is a drop down menu that says ‘With selected:’. Chose ‘Repair table’ and repair it. That should do it.
Your comments should come back to life and all should be well again.
[tags]matt-cutts mysql database phpmyadmin[/tags]
Categories: BloggerDesign, Commentary, Wordpress
Tags matt-cutts-mysql-database-phpmyadmin
Tuesday, January 2nd, 2007
Thanks! I actually was scared when this happened, and I appreciate your taking the time to post a fix!
When I first came across it, I freaked too.
Thank you for this simple fix! Worked like a charm from cPanel. I just repaired the entire database and that did the trick.
No problem. I’m glad to have helped.
thanyou for your solution. its very simple work. just repair our database.
[...] gawdy errors, and I’m behind a firewall that blocks the CPanel port. It’s a pretty easy fix [...]
Great help! Thanks!
Thanks a million. I didn’t know where to start with this problem but your solution was easy to follow and worked perfectly.
You’re welcome. I actually don’t think I’ve come across this issue since I upgraded to Wordpress 2.2. Not sure if that’s a fix or just luck.
Thank you !!
Thanks a lot, that was really simple.
Thanks for the advice.
I fixed the error in less than minute!!
Cheers