Database problems could not be repaired

  • lindsaypunk

    (@lindsaypunk)


    9 years ago

    In the midst of dealing with other issues I’m having with wordpress, I got the ‘Error establishing database connection’ when trying to load my site. On the wp-admin side, I got a slightly different error which prompted me to repair my databases.

    It then said that some database problems could not be repaired:

    wp_usermeta: 3 clients are using or haven’t closed the table properly
    wp_posts: 4 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: Table is marked as crashed
    wp_terms: 2 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 4 clients are using or haven’t closed the table properly
    wp_term_relationships: 3 clients are using or haven’t closed the table properly
    wp_commentmeta: 5 clients are using or haven’t closed the table properly

    Any suggestions as to how to fix these?

    Thanks!

Viewing 1 replies (of 1 total)
  • 1upnate

    (@1upnate)

    Do you have the options to dump all of the data from the database via a tool such as phpMyAdmin or something of that nature? You could be experiencing some InnoDB corruption within your tables which can be tricky to fix unless you’re able to go in and manually repair things.

    Also, how are you attempting to repair the database? Is it through a cPanel-like interface?

Viewing 1 replies (of 1 total)
  • The topic ‘Database problems could not be repaired’ is closed to new replies.