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

  1. Pingback: autoryzowany serwis samsung poznań

  2. Pingback: zobacz tutaj

  3. Pingback: grow taller by stretching spine

  4. Pingback: stretches to grow taller during puberty

  5. Pingback: Sex Shop

  6. Pingback: Création et référencement de sites web optimisé au maroc

  7. Pingback: warots.com.pl

  8. Pingback: creation site web maroc et referencement naturel pas cher

  9. Pingback: developpement de sites internet optimisé et leus referencement au maroc à tanger

  10. Pingback: tablet computer reviews

  11. Pingback: magmarelax.pl

  12. Pingback: resource

  13. Pingback: bill gardner

  14. Pingback: graphic designers long beach ca

  15. Pingback: where to buy zynga poker chips

  16. Pingback: zynga poker chips sellers

  17. Pingback: zynga poker chips cheat

  18. Pingback: armoir

  19. Pingback: consumer protection agency

  20. Pingback: navigate to this web-site

  21. Pingback: creation site internet marocl

  22. Pingback: création site internet maroc

  23. Pingback: creation site internet marocl

  24. Pingback: creation site web maroc

  25. Pingback: Home Improvement

  26. Pingback: Site ici

  27. Pingback: trouverez ici

  28. Pingback: PVC banners - satisfaction guaranteed

  29. Pingback: Je ai adoré ce

  30. Pingback: Création sur mesure et référencement SEO professionnel de projets web de toutes catégories à Tanger

  31. Pingback: BIENVENUS DANS NOTRE SITE WEB DEDIÉ À LA CRÉATION ET AU RÉFÉRENCEMENT PROFESSIONNEL DES SITES WEB SUR MESURE ET AU DESIGN ÉCLATANT

  32. Pingback: grand seiko watches

  33. Pingback: Eugenio Cope

  34. Pingback: poop bags for small dogs

  35. Pingback: Zhēnpí jiǎ yángjù

  36. Pingback: vancouver seo

  37. Pingback: Jamal Aniello

  38. Pingback: joanna shields Digital Business Academy

  39. Pingback: joanna shields ceo of tech city

  40. Pingback: catering supplies manchester

  41. Pingback: joanna shields tech city linkedin

  42. Pingback: création de sites au maroc

  43. Pingback: manchester catering equipment

  44. Pingback: Nous saurons faire respecter nos contrats en maîtrisant les délais avec le souci permanent de réaliser un travail de qualité avec satisfaction de nos clients

  45. Pingback: Nous pensons que pour atteindre nos objectifs à moyen et à long terme, notre activité et nos réalisations devront contribuer positivement au bien commun

  46. Pingback: brisbane web design course

  47. Pingback: Rafael Offerman

  48. Pingback: cliquez ici pour lire

  49. Pingback: Confier nous la réalisation de votre portail en le referençant

  50. Pingback: www.recuperodatichiavettausb.it

Leave a Comment

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