WordPress MySQL database error: Table is marked as crashed and should be repaired

After a few days out on a relaxing vacation, I came back and eager to  check my blog only to find out that I cannot login to the admin section. Instead of the usual login page, it forwarded to the upgrade database section. Something tells me this is not right. I never upgrade my WP nor installed any plugin before I left.

There is the usual button asking if I  want to upgrade the database. With the thought that I have 2 weeks worth of database backup, I proceeded with the upgrade process only to encounter the error below:

WordPress database error: [Table ‘./mydb_wrdp3/wp_options’ is marked as crashed and should be repaired]
INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘users_can_register’, ‘0’, ‘yes’)

 db_error

I hit F5 and refresh to isolate any browser conflict that may have arise and tried the upgrade again. Still, it won’t proceed with the upgrade so as a last resort I decided to repair the tables/db. This can be remedied by running a repair on your MySQL database from inside your cPanel.

NOTE: Before proceeding with the process below, make sure you have a backup of you database. You can make a backup using phpMyadmin. You have been warned.

To run a MySQL repair on all tables:

  • Login to the database using phpMyAdmin client.  This is usually found in CPanel tools. db_left
  • Click the name of the database on the left hand side and wait until all the tables has loaded.
  • You should see all of the tables of your selected database. db_tables
  • On the right hand side scroll to the bottom.  Click on "Check All"
    db_tables_check_all
  • From the drop-down menu "With selected" drop down box choose "Repair table" from the list.
    repair_db
  • If everything works out, you will see the something like the image below. success_db_repaired
  • If this doesn’t fix it, you can try going back and running the repair once more.
  • Clicking on the database name again should show no overhead for any of the tables.
  • You should be able to login again from the wp-admin page. That’s it!
    After going through this process and it did not solve your issue, I suggest to contact your hosting provider and engage their assistance……

1,138 Comments

  1. Pingback: garcinia cambogia extract

  2. Pingback: maduras

  3. Pingback: porno

  4. Pingback: ambulance worldwide

  5. Pingback: intermountainroundwoodassociation.org

  6. Pingback: advanced ambulance

  7. Pingback: free online video slots no download no registration

  8. Pingback: noctiquad.org

  9. Pingback: foro atletico madrid

  10. Pingback: Porno

  11. Pingback: evoteinspector.org

  12. Pingback: asiapacificforesightconference.org

  13. Pingback: noveentv19.info

  14. Pingback: uncommon-productivity.com

  15. Pingback: gdy miec swietne cialo

  16. Pingback: csr-bg.org

  17. Pingback: babatim.org

  18. Pingback: extremefuturistfestival.info

  19. Pingback: http://www.buyarticles.biz

  20. Pingback: officialryanfalconer.com

  21. Pingback: futurecitiesdevelopment.com

  22. Pingback: income insurance uk

  23. Pingback: http://www.buyarticles.biz

  24. Pingback: cerofalta.net

  25. Pingback: Videos De Maduras

  26. Pingback: gaztelanbidean.net

  27. Pingback: collegiatecompass.org

  28. Pingback: free viagra

  29. Pingback: friendsofcapemayrefuge.info

  30. Pingback: Pure Garcinia Cambogia Extract

  31. Pingback: New TV

  32. Pingback: wbfafrica.info

  33. Pingback: visit website

  34. Pingback: kliknij

  35. Pingback: witryna firmowa

  36. Pingback: buy viagra

  37. Pingback: code de la route

  38. Pingback: witryna www

  39. Pingback: strona

  40. Pingback: clickbank

  41. Pingback: merchant processing

  42. Pingback: hair salon in greenfield

  43. Pingback: Sims Urban Oasis

  44. Pingback: pebble tiles

  45. Pingback: standing pebble tile

  46. Pingback: lorenzo

  47. Pingback: Viagra

  48. Pingback: Best Movies On Netflix

  49. Pingback: ralph lauren polo

  50. Pingback: look here

Leave a Comment

Your email address will not be published. Required fields are marked *