wp_options: Table is marked as crashed

  • Hi,

    And wp_options: Table is marked as crashed and a few other errors my install advised me to post on here:

    wp_usermeta: 10 clients are using or haven’t closed the table properly
    wp_posts: 10 clients are using or haven’t closed the table properly
    wp_comments: 3 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 18 clients are using or haven’t closed the table properly
    wp_terms: 5 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 9 clients are using or haven’t closed the table properly
    wp_term_relationships: 9 clients are using or haven’t closed the table properly

    How do i resolve this please?

    Thanks in advance.

    Kes

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator t-p

    (@t-p)

    Try repairing the database tables.

    Thread Starter kesp

    (@kesp)

    Hi Tara,

    I did that and got those messages and the advice to post them on here.

    Kes

    Moderator t-p

    (@t-p)

    – Do you have a good backup of your DB that was taken prior to this issue?
    – If you do, restore your DB with it
    -If you don’t, ask your hosting provider if they have a backup of your site taken prior to this issue. If they do, ask them to restore your site.

    Thread Starter kesp

    (@kesp)

    I have a back up from last week

    Still a fair bit of work lost.

    May see if host has something more recent.

    Thanks,

    Kes

    Thread Starter kesp

    (@kesp)

    Hi again,

    I just used better delete revision to optimise the db and now i’m only left with a few errors:

    mydomain_697250_db1.wp_redirection_logs check Table is marked as crashed
    mydomain_697250_db1.wp_redirection_logs check 5 clients are using or haven’t closed the table properly
    mydomain_697250_db1.wp_redirection_logs check Found 85453688 deleted space in delete link chain. Should be 85472584
    mydomain_697250_db1.wp_redirection_logs check Found 384384 deleted rows in delete link chain. Should be 384386
    mydomain_697250_db1.wp_redirection_logs check record delete-link-chain corrupted
    mydomain_697250_db1.wp_redirection_logs check Corrupt

    These are related to the Redirection plugin.

    Do I really need to restore the entire db just because of these few tables?

    Kes

    Moderator t-p

    (@t-p)

    Do I really need to restore the entire db just because of these few tables?

    you may have to if you are unable repair tables.

    Thread Starter kesp

    (@kesp)

    the data in wp_redirection_logs has no value to me.

    Is it worth considering deleting these tables and reinstalling the plugin?

    Or perhaps emptying the tables of data?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘wp_options: Table is marked as crashed’ is closed to new replies.