Today I got this error message on my blog.

WordPress database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]

It’s not the first time. Last time I solved quickly searching on google what the "errno: 145" is. I found it is a database corruption problem.
I don’t know why that happened, I guess spammers are exaggerating in commenting my blog. But I know the solution:

$ mysql -u user_name -h host_name -p database_name
mysql> repair table wp_comments;

Saved here, for future problems, for people in troubles.


9 Responses to “WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]”  

  1. 1 Og Maciel

    Thanks a million!

    Cheers,

    Og

  2. 2 Jake Rutter

    Fantastic fix! How did you figure this out!

  3. 3 Blank Calendar

    Thanks for the fix!

  1. 1 MySQL issue when upgrading to WordPress 2.2.3 : Journal Of An Open Sourcee
  2. 2 The Linux Index » Og Maciel: MySQL issue when upgrading to WordPress 2.2.3
  3. 3 Errore su aggiornamento WordPress 2.2.3 « Lobotomia & WordPress
  4. 4 Fix Wordpress database error after upgrade « notes
  5. 5 Information on the wired. » Blog Archive » Getting spammed out
  6. 6 kozaru » Blog Archive » WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



Calendar

August 2007
M T W T F S S
« Jul   Sep »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Follow me

twitter flickr LinkedIn feed

Subscribe by email

Enter your email address:

Archives


Categories

Tag Cloud


Listening