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,127 Comments

  1. Pingback: Oakland County MI Small Business Lending

  2. Pingback: injury lawyer brampton

  3. Pingback: Small Company Loans Fastest Approval

  4. Pingback: Small Company Loans

  5. Pingback: Small Business Loans For High Risk Industries

  6. Pingback: toronto locksmiths downtown

  7. Pingback: free rape porn

  8. Pingback: porntube

  9. Pingback: spam viagra

  10. Pingback: personal injury lawyers brampton

  11. Pingback: spam viagra

  12. Pingback: buy sex online

  13. Pingback: free rape porn

  14. Pingback: lose weight pills

  15. Pingback: Sztachety Plastikowe

  16. Pingback: Ogrodzenia

  17. Pingback: Happy New Year from Poker Automatics

  18. Pingback: code promo

  19. Pingback: videos porno

  20. Pingback: Best design templates on the web

  21. Pingback: cheap treadmill repairs melbourne

  22. Pingback: Videos XXX

  23. Pingback: bandas tributo

  24. Pingback: Travod

  25. Pingback: http://afrokinkyhair.weebly.com/

  26. Pingback: Data Recovery

  27. Pingback: Small Company Loans Clarkston MI

  28. Pingback: kik usernames

  29. Pingback: kik friends

  30. Pingback: Clarkston Michigan Small Company Lending

  31. Pingback: http://hochzeitsbands-wien.at

  32. Pingback: buy steroid

  33. Pingback: buy steroid

  34. Pingback: more info here

  35. Pingback: How To Eliminate Foot Odor

  36. Pingback: check this

  37. Pingback: Authentic Designer Handbags for sale

  38. Pingback: love spells

  39. Pingback: home page

  40. Pingback: m5 Jalan Mutiara

  41. Pingback: more info here

  42. Pingback: pistolet a bille

  43. Pingback: Jack

  44. Pingback: drop shipment at 70%

  45. Pingback: Anthony Aires

  46. Pingback: park suites

  47. Pingback: ogloszenia pan

  48. Pingback: website

  49. Pingback: penis erections

  50. Pingback: meditation hawaii

Leave a Comment

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