Multisite Table Damage

  • Forson

    (@forson)


    9 years, 10 months ago

    These errors are crashing my site – does anyone have any suggestions as to how I can fix / repair?

    N.B. I received this list from the WP Database Repair programme so that option has already been used.

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 3 clients are using or haven’t closed the table properly
    wp_27_posts: 7 clients are using or haven’t closed the table properly
    wp_27_options: Table is marked as crashed
    wp_27_postmeta: 1 client is using or hasn’t closed the table properly
    wp_blogs: 1 client is using or hasn’t closed the table properly
    wp_sitemeta: 75 clients are using or haven’t closed the table properly

    Thanks,

    Andrew

Viewing 1 replies (of 1 total)
  • jayseae

    (@jayseae)

    9 years, 10 months ago

    The “hasn’t closed the table properly” are generally just warnings. It doesn’t mean that you should ignore them, but they are of less concern than the “marked as crashed” message.

    What you should do is repair the tables. Preferably soon.

    If you have access to phpMyAdmin, it is a fairly easy process – access phpMyAdmin through your control panel, select each database and choose “repair”.

    If not, it’s a little more difficult, but can be done from the command line as well (that is a little more complex).

    You can also probably contact your host and have them do it for you.

Viewing 1 replies (of 1 total)
  • The topic ‘Multisite Table Damage’ is closed to new replies.