Lee Odden

Fix: WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]

Lee Odden     Blogging Strategy

Wordpress ErrorFor 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]

Be the first to rate this post: PoorSo SoOKGoodAwesome

  • Get online marketing news, tips & tactics directly to your inbox. We respect your privacy.
  • This field is for validation purposes and should be left unchanged.

Related Posts You May Enjoy Reading:

Please read the Online Marketing Blog comment policy

About Lee Odden

@LeeOdden is the CEO of TopRank Marketing and editor of Online Marketing Blog. Cited for his expertise by The Economist, Forbes and the Wall Street Journal, he's the author of the book Optimize and presents internationally on integrated content, search, social media and influencer marketing. When not at conferences, consulting, or working with his talented team, he's likely on a beach somewhere doing absolutely nothing.