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: best condo

  2. Pingback: crown at robinson

  3. Pingback: Agua Dulce News Paper

  4. Pingback: Vis te koop

  5. Pingback: menopause supplement reviews

  6. Pingback: Restaurant Row

  7. Pingback: Crime scene cleaners

  8. Pingback: Source

  9. Pingback: leonardotransactions.com

  10. Pingback: dennysociety.org

  11. Pingback: Popcorntime

  12. Pingback: Crime scene cleanup

  13. Pingback: navigate here

  14. Pingback: findyourselfinsilvercity.org

  15. Pingback: buytramadoleasy.com

  16. Pingback: tre residences

  17. Pingback: Sexo Gay

  18. Pingback: toptrainingcenters.com

  19. Pingback: business communications

  20. Pingback: Popcorn Time

  21. Pingback: government grants

  22. Pingback: hollister women

  23. Pingback: barely legal girls

  24. Pingback: The Flow at East Coast

  25. Pingback: dougscottplymouth2013.org

  26. Pingback: masaj

  27. Pingback: biocontrolforconservation.org

  28. Pingback: Cheap Botox

  29. Pingback: Kids martial arts West Hempstead

  30. Pingback: currancare.org

  31. Pingback: benguet.net

  32. Pingback: interior design singapore

  33. Pingback: interior design portal singapore

  34. Pingback: zalany iphone

  35. Pingback: Banc de Swiss app

  36. Pingback: fleurymichonsports.com

  37. Pingback: my review here

  38. Pingback: Porno

  39. Pingback: Videos Gays

  40. Pingback: allo pizza vesoul

  41. Pingback: Videos Porno

  42. Pingback: elviajedelpapel.net

  43. Pingback: unicompinc.info

  44. Pingback: Clarkston, MI Small Business Loans

  45. Pingback: Oakland County Michigan Small Company Loans

  46. Pingback: porno

  47. Pingback: femmenaturalboost.com

  48. Pingback: Oakland County Small Company Loans

  49. Pingback: Schlüsseldienst Düsseldorf

  50. Pingback: porvairindia.com

Leave a Comment

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