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: globians.org

  2. Pingback: insurance

  3. Pingback: atlantadigitalmarketing.org

  4. Pingback: firstamendmenttv.com

  5. Pingback: republicansforjerrymcnerney.org

  6. Pingback: oferta

  7. Pingback: newbirthco.org

  8. Pingback: ibikenoho.org

  9. Pingback: zobacz tutaj

  10. Pingback: healingthreshold.org

  11. Pingback: polecam

  12. Pingback: find a personal injury lawyer brampton

  13. Pingback: upstatewhn.org

  14. Pingback: mocaforinstallers.org

  15. Pingback: Kids Martial Arts Franklin Square West Hempstead

  16. Pingback: official source

  17. Pingback: witryna firmowa

  18. Pingback: wisetrail

  19. Pingback: atxmedia.org

  20. Pingback: Beastiality Porn

  21. Pingback: Roost property management

  22. Pingback: blog

  23. Pingback: lingofriends.org

  24. Pingback: shadesgrey.net

  25. Pingback: optomechanic-bg.org

  26. Pingback: highdesertmusings.org

  27. Pingback: ifimav.org

  28. Pingback: hrwta.org

  29. Pingback: hotel-in-france.org

  30. Pingback: denver personal injury attorney

  31. Pingback: mountain-alliance.org

  32. Pingback: law firm

  33. Pingback: sextube

  34. Pingback: smartphonedefence.org

  35. Pingback: cebu prostitution

  36. Pingback: neuroskills.org

  37. Pingback: saut en parachute soulac

  38. Pingback: kingcastrol.org

  39. Pingback: globalintake.org

  40. Pingback: german-documentaries.org

  41. Pingback: sextube

  42. Pingback: where can i buy garcinia cambogia pills

  43. Pingback: reviews of garcinia cambogia

  44. Pingback: Los Angeles legal recruiter

  45. Pingback: cheap viagra

  46. Pingback: where can you buy pure garcinia cambogia

  47. Pingback: cheap viagra

  48. Pingback: garcinia cambogia reviews

  49. Pingback: questtour.org

  50. Pingback: Los Angeles legal recruiter

Leave a Comment

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