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]