Support » Fixing WordPress » wp_options: Table is marked as crashed and last repair failed

  • wp_options: Table is marked as crashed and last repair failed

    I have recently installed the latest version on a client site, and as of yesterday when a user attempts to access the site the following error message comes up:

    Error establishing a database connection

    Upon attempting to access /WP-ADMIN/ the following error is received:
    One or more database tables are unavailable. The database may need to be repaired.

    Then attempting to repair this error message was given,
    wp_options: Table is marked as crashed and last repair failed

    At one point it offered a piece of code to fix to wp-config.php
    define(‘WP_ALLOW_REPAIR’, true); – which I added then I was left with the following error:

    wp_options: Table is marked as crashed and last repair failed

    I have no Idea what I need to do next…any thoughts/ help please? I cant even get into the WP-Admin back yet on the site and it has been down for 2 days now, my client is NOT happy.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Mark Ratledge

    (@songdogtech)

    Forum Moderator

    Sounds like the database is toast. Do you have a backup? No? Does the web host have a backup? Ask them.

    If the database is toast and the web host doesn’t have a backup, you’ve learned a hard lesson about making sure you have your own backups. Always have a database – and preferably a theme and uploads backup – at all times. Pick a backup plugin and use it:
    http://wordpress.org/extend/plugins/search.php?q=backup

    Thanks for the quick reply…Luckily I do have everything backed up both with the plugin and at the host (thank goodness), but I wanted to see if it could be fixed without resorting to that or a rebuild.

    Thanks

    Moderator Mark Ratledge

    (@songdogtech)

    Forum Moderator

    Try restoring the database from the backup; no need to rebuild everything just yet.

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