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

  1. Pingback: naked teen girls

  2. Pingback: Adam

  3. Pingback: Olivia

  4. Pingback: Continue Reading

  5. Pingback: Visit Website

  6. Pingback: Read More Here

  7. Pingback: vancouver bus schedule

  8. Pingback: vancouver bus schedule

  9. Pingback: Reputation Management Services Atlanta Georgia

  10. Pingback: buy beastiality porn

  11. Pingback: Android Smartwatch Clearance

  12. Pingback: Ninja Blender Sale

  13. Pingback: Grand Rapids Videographer

  14. Pingback: cata bus

  15. Pingback: Free Beastiality Porn

  16. Pingback: Memory Foam Pillows

  17. Pingback: jak zalozyc sklep w Internecie

  18. Pingback: business

  19. Pingback: Atlanta GA SEO Services

  20. Pingback: Porno

  21. Pingback: desatascos en madrid

  22. Pingback: r4 3ds

  23. Pingback: business

  24. Pingback: temas-del-momento-2014

  25. Pingback: how to get a girlfriend back after she dumped you

  26. Pingback: serra viagra

  27. Pingback: peter beck

  28. Pingback: venta homeopatia online

  29. Pingback: 411 pain car accident

  30. Pingback: facebook marketing agency

  31. Pingback: 411-pain

  32. Pingback: floor jack reviews

  33. Pingback: best phytoceramides

  34. Pingback: High Risk Business Loans

  35. Pingback: High Risk Industry Small Company Loans

  36. Pingback: iphone poznań

  37. Pingback: Small Company Loans

  38. Pingback: wymiana szybki iphone

  39. Pingback: How To Get A Small Company Loan Promptly

  40. Pingback: Fast Small Business Lending

  41. Pingback: pablo adrian lari

  42. Pingback: Gmail Correo

  43. Pingback: appliance repair

  44. Pingback: protection one

  45. Pingback: Oakland County Michigan Small Business Lending

  46. Pingback: pizzeria vesoul

  47. Pingback: protect america home security

  48. Pingback: the doctors garcinia cambogia

  49. Pingback: Bates Sunset Appliance (323) 457-2315

  50. Pingback: Cb01

Leave a Comment

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