Support » Fixing WordPress » MySQL error messages

  • OK, before anyone points to similar threads, I’ve tried them all.

    I started getting the following error messages on one of my blogs:

    WordPress database error: [Can’t find file: ‘wp_comments.MYI’ (errno: 2)]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’

    WordPress database error: [Can’t find file: ‘wp_comments.MYI’ (errno: 2)]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’

    only primarily from within WP Admin, although there are some small error messages on the site itself, but it is otherwise still functioning.

    Naturally I figured it was a SQL/ db issue. I tried repairing the db via cPanel’s SQL repair facility with no success (I believe this is a front end to phpmyadmin), it was saying it couldn’t fix it.

    Following the instructions on a number of other threads, I tried fixing from within phpmyadmin itself. I’ve managed to get no options up what so ever to fix it, and keep getting this message:
    MySQL said: Documentation
    #1017 – Can’t find file: ‘wp_comments.MYI’ (errno: 2)

    Any thoughts or ideas are welcomed with thanks.

Viewing 1 replies (of 1 total)
  • Oh, and it’s not really a matter for me to contact my host, I’m running my own dedicated box through a hosting firm. They do provide a lot of support, but not down to the sql db error stage.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL error messages’ is closed to new replies.