Database crash, cannot be repaired

  • I just upgraded to WP 4.3.1 and it appears that the upgrade caused several database tables to crash and they cannot be repaired. They are:

    wp_usermeta: Table is marked as crashed
    wp_posts: 25 clients are using or haven’t closed the table properly
    wp_comments: Table is marked as crashed
    wp_options: Table is marked as crashed
    wp_postmeta: 24 clients are using or haven’t closed the table properly
    wp_terms: 23 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 24 clients are using or haven’t closed the table properly
    wp_term_relationships: 23 clients are using or haven’t closed the table properly
    wp_commentmeta: 21 clients are using or haven’t closed the table properly

    If anyone knows how to repair these tables, I appreciate any advice.

Viewing 1 replies (of 1 total)

  • You’ll have to use phpMyAdmin (or another SQL management tool) and use the ‘Repair’ option for those tables.

    Just as a word of cation though, with instances like this sometimes things can’t be repaired. If that’s the case you should aks your hosting company to restore from a backup.

    That’s why it’s always important to have a good backup strategy for your site. Unfortunately things like this can and do happen.

Viewing 1 replies (of 1 total)
  • The topic ‘Database crash, cannot be repaired’ is closed to new replies.

Tags