{"id":1363,"date":"2019-04-04T11:04:42","date_gmt":"2019-04-04T11:04:42","guid":{"rendered":"https:\/\/cloudhost.com.ng\/blog\/?p=1363"},"modified":"2019-04-04T11:06:44","modified_gmt":"2019-04-04T11:06:44","slug":"how-to-repair-crashed-wordpress-table-marked-as-crashedsolved","status":"publish","type":"post","link":"https:\/\/cloudhost.com.ng\/blog\/how-to-repair-crashed-wordpress-table-marked-as-crashedsolved\/","title":{"rendered":"How to Repair crashed WordPress table marked as crashed[Solved]"},"content":{"rendered":"\n<p>You were about logging in to your site and you see lots of errors  indicating that many or one of your WordPress database tables have crashed, If you are like me that manages  WordPress via SSH, Too lazy to login to phpmyadmin and repair the stated databases one after another, or both, it means you may be looking for the eariest way to Repair crashed WordPress table marked as crashed.<\/p>\n\n\n\n<p>I will show you how to do this in few simple steps, to get this done, you need access to edit your wp-config file<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1<\/h2>\n\n\n\n<p>Edit your Worpdress Config file wp-config.php file, add the below line<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">define('WP_ALLOW_REPAIR', true);<\/pre>\n\n\n\n<p>if you don&#8217;t add this, you will get the below<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"376\" src=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-1024x376.png\" alt=\"\" class=\"wp-image-1366\" srcset=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-1024x376.png 1024w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-300x110.png 300w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-768x282.png 768w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-640x235.png 640w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table-624x229.png 624w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-crashed-mysql-table.png 1471w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Save the WP config file, from there Go to this link http:\/\/Your-wordpress-root\/wp-admin\/maint\/repair.php replace  <br>Your-wordpress-root  with the url of your blog<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"427\" src=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-1024x427.png\" alt=\"repair and optimize wordpress cloudhost\" class=\"wp-image-1364\" srcset=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-1024x427.png 1024w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-300x125.png 300w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-768x320.png 768w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-640x267.png 640w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize-624x260.png 624w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-and-optimize.png 1286w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You will see above page when you visit that link, you might be tempted to click on Repair and Optimize Database,<strong> Don&#8217;t!<\/strong> Use <u>Repair Database <\/u>Option only<\/p>\n\n\n\n<p>Once you are done repairing you should see something like the below, if you see that some tables are still marked as crashed, revisit the repair link and run the steps again<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"687\" src=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-1024x687.png\" alt=\"Wordpress repair complete CloudHost\" class=\"wp-image-1365\" srcset=\"https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-1024x687.png 1024w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-300x201.png 300w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-768x516.png 768w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-640x430.png 640w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete-624x419.png 624w, https:\/\/cloudhost.com.ng\/blog\/wp-content\/uploads\/2019\/04\/repair-complete.png 1384w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Afterwards, simply visit your admin or Blog, and the tables would have been repaired.<\/p>\n\n\n\n<p>This Article\/Tutorial was brought to you by CloudHost Providers of Linux, Windows, Email, WordPress Hosting,  VPS Dedicated servers, Licenses and Microsoft services<\/p>\n\n\n\n<p>You can order <a href=\"https:\/\/cloudhost.com.ng\/wordpress-hosting\/\">WordPress dedicated hosting Plans<\/a> from <a href=\"https:\/\/cloudhost.com.ng\">CloudHost<\/a> for your WordPress sites, Our servers are reliable and we offer free migration <\/p>\n","protected":false},"excerpt":{"rendered":"<p>You were about logging in to your site and you see lots of errors indicating that many or one of your WordPress database tables have crashed, If you are like me that manages WordPress via SSH, Too lazy to login to phpmyadmin and repair the stated databases one after another, or both, it means you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yst_prominent_words":[],"class_list":["post-1363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/1363"}],"collection":[{"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/comments?post=1363"}],"version-history":[{"count":1,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/1363\/revisions"}],"predecessor-version":[{"id":1368,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/1363\/revisions\/1368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/media\/1364"}],"wp:attachment":[{"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/media?parent=1363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/categories?post=1363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/tags?post=1363"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/cloudhost.com.ng\/blog\/wp-json\/wp\/v2\/yst_prominent_words?post=1363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}