Database Repair Error – Told To Post Here

  • Resolved Another

    (@mackieinva)


    10 years, 10 months ago

    Went to log on and was told there was an error in the database and it could possibly be repaired. When I added to wp-config it ran the repair tool and told me to post this here:

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 1 client is using or hasn’t closed the table properly
    wp_posts: 1 client is using or hasn’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 1 client is using or hasn’t closed the table properly
    wp_terms: 1 client is using or hasn’t closed the table properly
    wp_term_taxonomy: 1 client is using or hasn’t closed the table properly
    wp_term_relationships: 1 client is using or hasn’t closed the table properly

    Any help would be appreciated.

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

  • What repair tool? Who is your host and do you have access to the database?

    Thread Starter Another

    (@mackieinva)

    I went to sign into the wp-admin error and was told there were database errors and to add this to the wp-config: define(‘WP_ALLOW_REPAIR’, true);

    After doing that it checked the database, gave me what I typed above and to ask for further assistance pasting this along with it. After going back to the front end databases were fine and I was allowed to login, so I’m not really sure if it was fixed or what but I’ll be looking into it. Thanks for responding.

    Sounds like it is ok. And if it ain’t broke don’t fix it.

    If you ever need to check it you can sign into your hosted account. Make sure there is a backup of your database. Then go in MySQLdatabase (here is where the backup options are sometimes).

    Choose the database you are working with by clicking on it in the left menu. On the right side of the page, you will see a listing of your tables. Click “Check All” and then from the drop down choose “Check Table.” There are several options there.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Repair Error – Told To Post Here’ is closed to new replies.