wp_comments’ is marked as crashed

  • newbienew

    (@newbienew)


    17 years ago

    On version 2.2.2 I am getting the following error:

    WordPress database error: [Table ‘./thegolde_wp_2/wp_comments’ is marked as crashed and should be repaired]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’

    I DO NOT want to lose the comments that existed before the db crash. In reading through previous posts, I found this topic, but the person had no comments to lose, so I was nervous about following those steps as I have lots of comments that I would rather not sacrifice.

    I am totally new to dealing with any of this, so as much detail as possible would be so very appreciated.

    Gratefully yours.

Viewing 6 replies - 1 through 6 (of 6 total)
  • whooami

    (@whooami)

    you dont have a choice. Use phpmyadmin and go in and repair the table.

    And if youre so worried about losing stuff, you might want to upgrade — you may lose alot more if your site is exploited.

    Thread Starter newbienew

    (@newbienew)

    Thank you for the reply!

    It sounds like I am going to lose the commetns.

    I have the plugin that automatically backs everything up and then sends me the file.

    Is there a way to get the comments from that file and upload them?

    whooami

    (@whooami)

    repairing the tables prevents you from losing the data, thats the whole point.

    how do you repair the db?

    this is happening to me too

    I upgraded to the newest version of WP and the system updated my DB but the comments tables are still marked as crashed?

    any suggestions?

    yes, you can repair the database if you have shell access to the server (or you ask your provider).
    you can repair this with myisamchk -r <path to database>

    see this for a guide. it is in german but you can scroll down to “myisamchk” and see the shell commands ?? i hope this helps you!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘wp_comments’ is marked as crashed’ is closed to new replies.