WP Database repair! What gives please help

  • I couldn’t access my wp-admin (the front end is working so far).

    WP System told me to add the WP_ALLOW_REPAIR to true in wp-config.php.

    I did.

    I pressed the repair database and got the following messages:

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 9 clients are using or haven’t closed the table properly
    wp_posts: 21 clients are using or haven’t closed the table properly
    wp_comments: 33 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 28 clients are using or haven’t closed the table properly
    wp_terms: 3 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 18 clients are using or haven’t closed the table properly
    wp_term_relationships: 18 clients are using or haven’t closed the table properly
    wp_commentmeta: 26 clients are using or haven’t closed the table properly

    Is this a solvable problem, or should I… just… find some hills to run to :/

    Main, business site. Worried. What gives? Please help.

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

  • Unless you have a recent backup of your database that you can re-instate, you should talk to your hosting company and get them to restore a backup from when you know the site was working.

    When it gets back up… take a back up again. Databases are good and all, but they can (and do) crash, leaving you with what you’ve got now.

    Thread Starter Momekh

    (@momekh)

    Hills it is then. :/

    Thanks @catacaustic… I was fearing that was the only way out of this.

    Thread Starter Momekh

    (@momekh)

    There is one thing though:

    The site has an online ordering form. The whole thing is working!!

    IF the DB is gone, then how come the front-end is working??

    The only problem is while accessing wp-admin …
    Maybe there is hope? Any more clues?

    The database is not all gone. It’s corrupted. There’s a big difference. Thins may still work, but it’s in an unstable state and can’t be relied on to get the right data at any time, or to save anything correctly. From your post before the main table that’s got issues is wp_options and there’s a lot of options stored in there for the admin area, so that’s the most likely reason that I can think of for the front working but the admin not. Also, are you using a caching plugin at all? If you are it may have easily created a proper HTML version of the page to serve out so you’re not touching the database with that page/pages.

    Thread Starter Momekh

    (@momekh)

    Makes sense. I have a caching plugin.

    Also, I have a SQL file backup (via a backup plugin).

    Here’s what I’m thinking of doing:

    • Hit up Hostgator, and see if they can fix this?
    • If that fails, I can log in via PHPMyAdmin and try to do something with the sql backup that I have

    Frankly, I don’t know what kind of data the .sql file will have. Will it have images as well!? It’s a image-heavy site. Hmmm…

    Thanks again. ??

    Images are all stored in the file system, so they won’t be affected… however the way that WordPress references the images is stored in the database, so you still need the database for them.

    To restore the database backup you can use these instructions. That would be my first choice on what to do, but if you’re ot too sure of doing that ask your hosting company first and see what they can do.

    Thread Starter Momekh

    (@momekh)

    OK, so the thing just started working again. On its own.

    This is not the first time technology ghosts have wrecked and then saved the day. :/

    Alhumdulillah

    Thank you so much for the help again!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WP Database repair! What gives please help’ is closed to new replies.