• After automatic update of WordPress to 4.2.4 I had to repair my database. I got the following problems and it told me to post them here:

    wp_users: 59 clients are using or haven’t closed the table properly
    wp_usermeta: 79 clients are using or haven’t closed the table properly
    wp_posts: 64 clients are using or haven’t closed the table properly
    wp_comments: 59 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 66 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 8 clients are using or haven’t closed the table properly
    wp_commentmeta: 58 clients are using or haven’t closed the table properly

    Can anyone help me identify any actions I should take to amend these problems?

    Thanks

Viewing 1 replies (of 1 total)
  • It’s NOT my field. But what I would try would be
    – first, make a dabatase backup (with phpmyadmin: https://codex.wordpress.org/Backing_Up_Your_Database , or ask your web host)
    – second, place the blog in maintenance mode (simply create a file called .maintenance and place it at the root of your wordpress folder, make sure to delete the file when you want the maintenance to end)
    – third, in phpmyadmin or in your hosting panel, select the database, select all tables, and choose “Repair”.

    … or contact your web host and ask them to do the repair themselves, hopefully they’ll be glad to help 🙂
    (but make sure you have a backup first)

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