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: no deposit bonus

  2. Pingback: garcinia cambogia does not work

  3. Pingback: Cash Advance

  4. Pingback: forskolin supplement

  5. Pingback: Marilyn Monroe Condos

  6. Pingback: Cineblog01

  7. Pingback: Cineblog01

  8. Pingback: for business

  9. Pingback: Tridel Ovation Condos Mississauga

  10. Pingback: grand rapids videographer

  11. Pingback: remium pure forskolin reviews

  12. Pingback: natural garcinia cambogia

  13. Pingback: SEO Bristol

  14. Pingback: forskolin fat burner

  15. Pingback: where do i buy garcinia cambogia

  16. Pingback: sell your bitcoin

  17. Pingback: forskolin supplements

  18. Pingback: harga kasur busa

  19. Pingback: forskolin reviews

  20. Pingback: website

  21. Pingback: gambling

  22. Pingback: buy cigars

  23. Pingback: cigar

  24. Pingback: cigar

  25. Pingback: Farshad Farivar

  26. Pingback: Farshad Farivar

  27. Pingback: swimwear

  28. Pingback: porno

  29. Pingback: leto 2015 kusadasi

  30. Pingback: sexo gratis

  31. Pingback: Agence web au Maroc a Tanger de creation de sites

  32. Pingback: porno

  33. Pingback: paket honeymoon

  34. Pingback: panapis air al jabbar

  35. Pingback: glitter tatts

  36. Pingback: coffee body scrub

  37. Pingback: creation site web maroc tanger

  38. Pingback: Naturkosmetik

  39. Pingback: referencement de sites web au maroc a tanger

  40. Pingback: zynga poker chips for sale

  41. Pingback: Kosmetik online shop

  42. Pingback: buy zynga poker chips

  43. Pingback: agence web installée à tanger au maroc de création de sites et référencement

  44. Pingback: referencement site internet maroc tanger

  45. Pingback: creation site web tanger maroc

  46. Pingback: polecam link

  47. Pingback: création site web tanger au maroc et referencement

  48. Pingback: creation et referencement de sites internet à tanger pas cher

  49. Pingback: agence de creation de sites internet à tanger

  50. Pingback: zobacz tutaj

Leave a Comment

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