Error Establishing Connection Error

  • I have been hosting WP Multi-Site for several years for my high school students. This year I have gotten a few error establishing database connection errors. I enabled ALLOW REPAIR and got these errors and not sure how to fix:

    wp_usermeta: 9 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: 12 clients are using or haven’t closed the table properly
    wp_commentmeta: 3 clients are using or haven’t closed the table properly
    wp_blogs: 8 clients are using or haven’t closed the table properly
    wp_sitemeta: 19 clients are using or haven’t closed the table properly
    wp_registration_log: 3 clients are using or haven’t closed the table properly
    wp_blog_versions: 2 clients are using or haven’t closed the table properly

Viewing 3 replies - 1 through 3 (of 3 total)

  • That basically means that those database tables have crashed.

    There’s two solutions for this.

    First, you should log into your hosting accounts admininistraiton panel (not your WordPress admin) and look for some sort of database tools like phpMyAdmin and use that to try to repair the tables. This may or may not work depending on how far the issues with the tables have gone.

    Secondly, if that doesn’t work you’ll need to restore the tables from a backup. If you don’t have a backup (you should!!) you can aks your hosting company to revert the site back to a known date when it was working.

    Thread Starter chargertech

    (@chargertech)

    I host on my own Apple Xserve. I’ll check PMA. I have backups sent to GD everyday, never used them though. So, I’ll have to guide that out. What would cause only handful out of almost 200 sites to get this error?

    Could be anything really. MySQL has a bit of a reputation for “issues” like this sometimes. While it’s not common, it’s still common enough so good backups are always hihgly recommended.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error Establishing Connection Error’ is closed to new replies.