Support » Fixing WordPress » WordPress database error: [Can’t open file: ‘wp_comments.MYD’. (errno: 144)]

  • Resolved fmckinnon

    (@fmckinnon)


    Hey Ya’ll –

    I’m not sure when it happened, but regardless of which “theme” I’m using, I’m getting the following error in the headers of each page. Any help on resolving this? I have access to mySQL database and phpMyAdmin, so I can get to the database if necessary.

    As a matter of fact, I’ve just logged in, and when I attempted to browse the wp_comments table, I get:
    SQL query: Edit

    SHOW KEYS FROM wp_comments ;

    MySQL said: Documentation
    #1016 – Can’t open file: ‘wp_comments.MYD’. (errno: 144)

    Any help would be appreciated!
    FRED MCKINNON
    http://www.fredmckinnon.com/myblog/

Viewing 15 replies - 1 through 15 (of 15 total)
  • Let your host know, they might be able to help…

    Thread Starter fmckinnon

    (@fmckinnon)

    Yosemite –
    I *AM* the host, LOL.

    Then you’re fscked!

    Seriously, something got corrupt. A repair attempt may have already been done, but you could try it manually.

    Or, restore your backup.

    To be very clear: This is a MySQL issue.

    mmm. Shoulda said:

    Seriously, something got corrupt. A [MySQL] repair attempt may have already been done, but you could try it manually.

    that should be just a corrupt table, use phpmyadin, go in repair it, or if you want to use the shell (since youre the host)

    mysql> REPAIR TABLE wp_comments;

    Thread Starter fmckinnon

    (@fmckinnon)

    aaah – logged into phpmyadmin and did: REPAIR TABLE wp_comments;

    Worked like a charm – phew!

    Hey Fred and all contributors… you saved the day. I had the same problem and fixed it right away. Thanks.

    Keilya

    (@fantasycrusader)

    Thanks for the heads up on this one! I was wondering what on earth happened. =S Scared the hell outta me.

    Man! It happened to me too. I wonder why it hits wp_comments? Possibly related to comment spammers abusing the scripts, but this likely points to a WP-bug.

    bhyde

    (@bhyde)

    Just happened to one of the blogs under my care too, the repair table fixed it. Version 2.0.5

    But what happens if “repair” is not possible.

    I got this error after pushing a backupfile into the DB. Repair the table brougt the next error. The DB wasnt able to create a temp-DB. So I saw that I simply forgot to chmod the DB-Folder to 777.

    Now its working fine

    Good luck

    P.S. Yes, germans are to stupid to learn english 😉

    Does anyone have any advice for the technically challenged who are facing this error and have know idea what phpmyadmin is or how to use it? pretty please? 🙂

    lararose.com/blog

    @ LaraRose
    click on my username and then the contact tab at top of my test blog. I’ll lead you through it.

    It is interesting that’s always the wp_comments table that gets corrupted. Maybe it’s the most added-to table what with all the spammers. I saw a suggestion that this sort of corruption usually occurs because of an out-of-disk-space condition. This is probably what caused it for me recently.

    Interesting: if you google for “Can’t open file: wp_comments.MYD”, the top item is this page. The other 11,000+ items are links to broken WordPress installations.

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘WordPress database error: [Can’t open file: ‘wp_comments.MYD’. (errno: 144)]’ is closed to new replies.