Some database problems could not be repaired.

  • SiuSang

    (@siusang)


    9 years, 12 months ago

    how to fix that database error? please help.. thanks.

    wp_usermeta: 3 clients are using or haven’t closed the table properly
    wp_posts: 8 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 13 clients are using or haven’t closed the table properly
    wp_terms: 2 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 3 clients are using or haven’t closed the table properly
    wp_term_relationships: 7 clients are using or haven’t closed the table properly

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 12 months ago

    How are you hosting your site? Shared hosting or your own VPS?

    Thread Starter SiuSang

    (@siusang)

    9 years, 12 months ago

    Hello Steve

    I use google cloud Compute Engine to host my website, thanks.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 12 months ago

    OK… here are the steps:

    1. shut down httpd (so no one can access your site and the database is not in use.

    2. use mysqlcheck to repair the db

    mysqlcheck databasename --repair

    3. run mysqlcheck again to make sure all tables are OK

    mysqlcheck databasename

    4. restart httpd to bring your site back up

    if your account doesn’t have access to the database you may need to add the account parameters;

    mysqlcheck -u user -p databasename --repair

    Thread Starter SiuSang

    (@siusang)

    9 years, 12 months ago

    thanks!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    9 years, 12 months ago

    Once you have the DB back, check the server logs to see if you can see anything that might have caused the DB to crash.

    On a standard Linux system, that would be /var/log/messages though various Linuxes (Linuxi? Linuces?) might use a different file.

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

The topic ‘Some database problems could not be repaired.’ is closed to new replies.