{"id":1806,"date":"2015-04-17T06:11:11","date_gmt":"2015-04-17T05:11:11","guid":{"rendered":"https:\/\/www.uk-cheapest.co.uk\/support\/?p=1806"},"modified":"2015-04-17T06:23:08","modified_gmt":"2015-04-17T05:23:08","slug":"unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired","status":"publish","type":"post","link":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/","title":{"rendered":"Unable to execute SQL: Table &#8216;.\/db\/wp_comments&#8217; is marked as crashed and should be repaired"},"content":{"rendered":"<p><strong>How to Fix: Crashed MySQL Database<\/strong><\/p>\n<p>If your database is marked as crashed and needs to be repaired you may find it will not backup (or migrate) using mysqldump. In these instances you need to login to mysql and run the check\/repair process. It&#8217;s very easy.<\/p>\n<p>First, you need to authenticate to the mysql server. The example below is for Plesk servers:<\/p>\n<pre># mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/pre>\n<p>Let&#8217;s check the table and see the current status:<\/p>\n<pre># mysql&gt; check table db.wp_comments;\r\n+-----------------------------------+-------+----------+-----------------------------------------------------------+\r\n| Table | Op | Msg_type | Msg_text |\r\n+-----------------------------------+-------+----------+-----------------------------------------------------------+\r\n| db.wp_comments | check | warning | Table is marked as crashed |\r\n| db.wp_comments | check | error | Size of datafile is: 26984448 Should be: 26985708 |\r\n| db.wp_comments | check | error | Corrupt |\r\n+-----------------------------------+-------+----------+-----------------------------------------------------------+\r\n3 rows in set (0.00 sec)<\/pre>\n<p>Now we can see the problem, let&#8217;s run the REPAIR TABLE facility:<\/p>\n<pre># mysql&gt; repair table db.wp_comments;\r\n+-----------------------------------+--------+----------+-------------------------------------------------------+\r\n| Table | Op | Msg_type | Msg_text |\r\n+-----------------------------------+--------+----------+-------------------------------------------------------+\r\n| db.wp_comments | repair | info | Found block that points outside data file at 26984408 |\r\n| db.wp_comments | repair | status | OK |\r\n+-----------------------------------+--------+----------+-------------------------------------------------------+\r\n2 rows in set (4.23 sec)<\/pre>\n<p>That&#8217;s now all fixed. Yes, it&#8217;s that easy! Let&#8217;s check the table again to be 100% sure:<\/p>\n<pre># mysql&gt; check table db.wp_comments;\r\n+-----------------------------------+-------+----------+----------+\r\n| Table | Op | Msg_type | Msg_text |\r\n+-----------------------------------+-------+----------+----------+\r\n| db.wp_comments | check | status | OK |\r\n+-----------------------------------+-------+----------+----------+\r\n1 row in set (0.05 sec)<\/pre>\n<p>You can now transfer your MySQL database, dump it or re-migrate it as required.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Fix: Crashed MySQL Database If your database is marked as crashed and needs to be repaired you may find it will not backup (or migrate) using mysqldump. In these instances you need to login to mysql and run the check\/repair process. It&#8217;s very easy. First, you need to authenticate to the mysql server. &#8230; <a title=\"Unable to execute SQL: Table &#8216;.\/db\/wp_comments&#8217; is marked as crashed and should be repaired\" class=\"read-more\" href=\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\" aria-label=\"More on Unable to execute SQL: Table &#8216;.\/db\/wp_comments&#8217; is marked as crashed and should be repaired\">Read more&#8230;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[245,63,64],"tags":[],"class_list":["post-1806","post","type-post","status-publish","format-standard","hentry","category-mysql-support","category-plesk-support","category-wordpress-support"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Unable to execute SQL: Table &#039;.\/db\/wp_comments&#039; is marked as crashed and should be repaired - UK-Cheapest.co.uk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unable to execute SQL: Table &#039;.\/db\/wp_comments&#039; is marked as crashed and should be repaired\" \/>\n<meta property=\"og:description\" content=\"How to Fix: Crashed MySQL Database If your database is marked as crashed and needs to be repaired you may find it will not backup (or migrate) using mysqldump. In these instances you need to login to mysql and run the check\/repair process. It&#8217;s very easy. First, you need to authenticate to the mysql server. ... Read more...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\" \/>\n<meta property=\"og:site_name\" content=\"UK-Cheapest.co.uk\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-17T05:11:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-04-17T05:23:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"439\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"UKC\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:site\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UKC\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\",\"name\":\"Unable to execute SQL: Table '.\/db\/wp_comments' is marked as crashed and should be repaired - UK-Cheapest.co.uk\",\"isPartOf\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#website\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"UK-Cheapest.co.uk\",\"item\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unable to execute SQL: Table &#8216;.\/db\/wp_comments&#8217; is marked as crashed and should be repaired\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#website\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\",\"name\":\"UK-Cheapest.co.uk\",\"description\":\"Cheap Domain Names, Web Hosting, Site Builder &amp; Web Security\",\"publisher\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.uk-cheapest.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#organization\",\"name\":\"UKC\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png\",\"contentUrl\":\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png\",\"width\":217,\"height\":55,\"caption\":\"UKC\"},\"image\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/ukchelpdesk\",\"https:\/\/www.instagram.com\/ukc_hosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/135cf981b8a3a120603fcbc027eed746\",\"name\":\"UKC\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g\",\"caption\":\"UKC\"},\"sameAs\":[\"https:\/\/www.uk-cheapest.co.uk\"],\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/author\/colin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Unable to execute SQL: Table '.\/db\/wp_comments' is marked as crashed and should be repaired - UK-Cheapest.co.uk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/","og_locale":"en_GB","og_type":"article","og_title":"Unable to execute SQL: Table '.\/db\/wp_comments' is marked as crashed and should be repaired","og_description":"How to Fix: Crashed MySQL Database If your database is marked as crashed and needs to be repaired you may find it will not backup (or migrate) using mysqldump. In these instances you need to login to mysql and run the check\/repair process. It&#8217;s very easy. First, you need to authenticate to the mysql server. ... Read more...","og_url":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/","og_site_name":"UK-Cheapest.co.uk","article_published_time":"2015-04-17T05:11:11+00:00","article_modified_time":"2015-04-17T05:23:08+00:00","og_image":[{"width":768,"height":439,"url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg","type":"image\/jpeg"}],"author":"UKC","twitter_card":"summary_large_image","twitter_creator":"@ukchelpdesk","twitter_site":"@ukchelpdesk","twitter_misc":{"Written by":"UKC","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/","name":"Unable to execute SQL: Table '.\/db\/wp_comments' is marked as crashed and should be repaired - UK-Cheapest.co.uk","isPartOf":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website"},"breadcrumb":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/unable-to-execute-sql-table-dbwp_comments-is-marked-as-crashed-and-should-be-repaired\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"UK-Cheapest.co.uk","item":"https:\/\/www.uk-cheapest.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"Unable to execute SQL: Table &#8216;.\/db\/wp_comments&#8217; is marked as crashed and should be repaired"}]},{"@type":"WebSite","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","name":"UK-Cheapest.co.uk","description":"Cheap Domain Names, Web Hosting, Site Builder &amp; Web Security","publisher":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.uk-cheapest.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization","name":"UKC","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","contentUrl":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","width":217,"height":55,"caption":"UKC"},"image":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ukchelpdesk","https:\/\/www.instagram.com\/ukc_hosting\/"]},{"@type":"Person","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/135cf981b8a3a120603fcbc027eed746","name":"UKC","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g","caption":"UKC"},"sameAs":["https:\/\/www.uk-cheapest.co.uk"],"url":"https:\/\/www.uk-cheapest.co.uk\/support\/author\/colin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1806"}],"collection":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/comments?post=1806"}],"version-history":[{"count":6,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1806\/revisions"}],"predecessor-version":[{"id":1812,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1806\/revisions\/1812"}],"wp:attachment":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/media?parent=1806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/categories?post=1806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/tags?post=1806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}