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

  1. Pingback: witryna

  2. Pingback: kids

  3. Pingback: kliknij link

  4. Pingback: Viagra pills

  5. Pingback: creation de site web à tange au marocr

  6. Pingback: videos porno

  7. Pingback: how to buy zynga poker chips

  8. Pingback: Agence web au Maroc installée à tanger

  9. Pingback: videos de incesto

  10. Pingback: free themes download

  11. Pingback: referencement de sites internet à tanger au maroc avec optimisation top 10 google

  12. Pingback: videos de incesto

  13. Pingback: cheap zynga poker chips

  14. Pingback: developpeur de sites internet à tanger et referenceur au Maroc

  15. Pingback: referencement site web tanger maroc avec optimisation top 10 google

  16. Pingback: polecam link

  17. Pingback: prix création site web maroc

  18. Pingback: création site internet tanger

  19. Pingback: developeur tanger maroc

  20. Pingback: tarif création referencement site internet tanger

  21. Pingback: free tv shows

  22. Pingback: lotion for tattoo care

  23. Pingback: fake video

  24. Pingback: دانلود فیلم

  25. Pingback: vipcolor fake

  26. Pingback: creation site web tanger

  27. Pingback: referencement site internet tanger

  28. Pingback: Read More Here

  29. Pingback: Notre metier est le webdesign et disposant d'une longue exprience dans ces domaines de technologies nouvelles. Nous avons acquis une riche exprience par la réalisation et le référencement de nombreux sites web de differentes catégories au Maroc. Nous inte

  30. Pingback: création site web maroc

  31. Pingback: webdesigner maroc

  32. Pingback: création site internet maroc

  33. Pingback: En augmentant votre trafic avec des internautes ciblés, vous constaterez surement que vos ventes s’envolent pour atteindre les meilleurs sommets, et vous obtiendrez une stratégie d'optimisation de moteurs de recherche personnalisée conçue spécialement pou

  34. Pingback: confier nous la realisation de votre projet virtuel des maintenant

  35. Pingback: developeur sites internet maroc

  36. Pingback: référencement avec backlinks edu gov pas cher

  37. Pingback: referencement naturel seo pas cher

  38. Pingback: developpeur freelance

  39. Pingback: referencement naturel seo pas cher

  40. Pingback: bikini body chains

  41. Pingback: referencement naturel seo pas cher

  42. Pingback: online cash loans

  43. Pingback: Source

  44. Pingback: webdesigneur freelance

  45. Pingback: our site

  46. Pingback: porno

  47. Pingback: Novelty Techpoint

  48. Pingback: Contactos Amateur

  49. Pingback: real aikido

  50. Pingback: création de sites internet au maroc et référencement pas cher

Leave a Comment

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