Database corrupted

  • Hi –
    I have a blog that’s been up and running for a couple of months. All of a sudden I got a database error – and intsructions to copy code into wp-config to repair. After repairing, I got the following messages along with a suggestion to seek help on the forums. So, here I am:

    wp_usermeta: 1 client is using or hasn’t closed the table properly
    wp_posts: 3 clients are using or haven’t closed the table properly
    wp_comments: 2 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 3 clients are using or haven’t closed the table properly
    wp_terms: 1 client is using or hasn’t closed the table properly
    wp_term_taxonomy: 2 clients are using or haven’t closed the table properly
    wp_term_relationships: 2 clients are using or haven’t closed the table properly

    The blog seems to be functioning okay (and most recent post is there) but if something is damaged, I’d like to repair it so it doesn’t happen again. Thx.

Viewing 1 replies (of 1 total)

  • The very first thing to do is back up everything, so if trying to repair makes it worse, you can recover.

    Then if you are familiar with phpMyAdmin, you can repair the tables with it. Follow the directions in the Codex here.

    If not, try to install a plugin, such as WP-DBManager that can do database repairs.

Viewing 1 replies (of 1 total)
  • The topic ‘Database corrupted’ is closed to new replies.