Database repair error

  • ace2ice

    (@ace2ice)


    10 years, 10 months ago

    Hello,

    I got a notice to repair my website’s database, followed the instruction and got this result in the end

    wp_usermeta: 1 client is using or hasn’t closed the table properly
    wp_posts: 19 clients are using or haven’t closed the table properly
    wp_comments: 7 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 25 clients are using or haven’t closed the table properly
    wp_terms: 14 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 15 clients are using or haven’t closed the table properly
    wp_term_relationships: 15 clients are using or haven’t closed the table properly
    wp_commentmeta: 6 clients are using or haven’t closed the table properly

    Do let me know what other steps i need to take

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • esmi

    (@esmi)

    10 years, 10 months ago

    Try:
    – switching to the default theme by renaming your current theme’s folder inside wp-content/themes and adding “-old” to the end of the folder name using FTP or whatever file management application your host provides.

    – resetting the plugins folder by FTP or phpMyAdmin.

    – then repairing your database tables.

    Thread Starter ace2ice

    (@ace2ice)

    10 years, 10 months ago

    Thanks for your response esmi,
    The website is actually quite busy so im guessing i would try out your suggestions at night when we have few visitors on the site.

    Moderator Yui

    (@fierevere)

    永子

    10 years, 10 months ago

    Its better do not delay with table repairing, and do so as soon as possible.

    Thus.. It will be better if you change database/table storage engine to InnoDB , its transactional and crash proof it can be better performance even
    http://rtcamp.com/wordpress-nginx/tutorials/mysql/myisam-to-innodb/

    cogdog

    (@cogdog)

    10 years, 8 months ago

    I’ve had this happen with 2 sites recently — I have found that the suggestion to modify wp_config.php to include the database repair fails every time to fix.

    What has worked is logging into phpMyAdmin, selecting the affected tables, and running a repair table.

    If you do not have a routine setup to back up your databases, do so right away. My host provides nightly backups, if yours does not, then look at the plugins that do db backups.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database repair error’ is closed to new replies.