{"id":6510,"date":"2021-04-30T20:59:32","date_gmt":"2021-04-30T20:59:32","guid":{"rendered":"https:\/\/truehost.co.ke\/support\/?post_type=ht_kb&#038;p=6510"},"modified":"2024-06-07T13:03:09","modified_gmt":"2024-06-07T13:03:09","password":"","slug":"how-to-repair-mysql-database-tables","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/","title":{"rendered":"How to Repair MySQL Database Tables."},"content":{"rendered":"\n<p>Sometimes the database tables can crash. In such cases you need to repair the database. In this guide we will learn how to repair database tables through phpMyAdmin.<\/p>\n\n\n\n<p>1.Log in to Cpanel and scroll to the database section.<\/p>\n\n\n\n<p>2.Click on phpMyAdmin to open.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"172\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png\" alt=\"\" class=\"wp-image-7405\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png 973w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-300x53.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-768x136.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-50x9.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-920x163.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-600x106.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-320x57.png 320w\" sizes=\"auto, (max-width: 973px) 100vw, 973px\" \/><\/figure>\n\n\n\n<p>2.Navigate to the\u00a0<strong>Databases<\/strong>\u00a0tab and click on the name of the desired database. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"254\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7.png\" alt=\"\" class=\"wp-image-7406\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7.png 877w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-300x87.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-768x222.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-50x14.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-600x174.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-320x93.png 320w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>3.Select the tables that need repair by ticking the check-boxes on the left of the table names. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"520\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png\" alt=\"\" class=\"wp-image-7407\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png 900w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-300x173.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-768x444.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-50x29.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-600x347.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-320x185.png 320w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p>4.From the\u00a0<strong>With Selected:<\/strong>\u00a0drop-down menu choose\u00a0<strong>Repair Table<\/strong>. The tables will be automatically repaired and you will be presented with a page showing the results from the repair operation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"200\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-1024x200.png\" alt=\"\" class=\"wp-image-7408\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-1024x200.png 1024w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-300x59.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-768x150.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-50x10.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-920x179.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-600x117.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-320x62.png 320w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png 1256w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>That is all your database is now repaired.<\/p>\n\n\n\n<p><strong>Note: <\/strong>Only <strong>MyISAM<\/strong> tables can be repaired. <strong>InnoDB<\/strong> databases cannot be repaired. However, InnoDB is more resilient to crashing and is recommended for MySQL databases.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes the database tables can crash. In such cases you need to repair the database. In this guide we will learn how to repair database tables through phpMyAdmin. 1.Log in to Cpanel and scroll to the database section. 2.Click on phpMyAdmin to open. 2.Navigate to the\u00a0Databases\u00a0tab and click on the name of the desired database. [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-6510","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":137,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Patrick K","author_nicename":"patrick","author_url":"https:\/\/truehost.com\/support\/author\/patrick\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Repair MySQL Database Tables. -<\/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:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Repair MySQL Database Tables. -\" \/>\n<meta property=\"og:description\" content=\"Sometimes the database tables can crash. In such cases you need to repair the database. In this guide we will learn how to repair database tables through phpMyAdmin. 1.Log in to Cpanel and scroll to the database section. 2.Click on phpMyAdmin to open. 2.Navigate to the\u00a0Databases\u00a0tab and click on the name of the desired database. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T13:03:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/\",\"name\":\"How to Repair MySQL Database Tables. -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png\",\"datePublished\":\"2021-04-30T20:59:32+00:00\",\"dateModified\":\"2024-06-07T13:03:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-repair-mysql-database-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Repair MySQL Database Tables.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Repair MySQL Database Tables. -","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:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/","og_locale":"en_US","og_type":"article","og_title":"How to Repair MySQL Database Tables. -","og_description":"Sometimes the database tables can crash. In such cases you need to repair the database. In this guide we will learn how to repair database tables through phpMyAdmin. 1.Log in to Cpanel and scroll to the database section. 2.Click on phpMyAdmin to open. 2.Navigate to the\u00a0Databases\u00a0tab and click on the name of the desired database. [&hellip;]","og_url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/","article_modified_time":"2024-06-07T13:03:09+00:00","og_image":[{"url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/","url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/","name":"How to Repair MySQL Database Tables. -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/#primaryimage"},"image":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png","datePublished":"2021-04-30T20:59:32+00:00","dateModified":"2024-06-07T13:03:09+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/#primaryimage","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main.png"},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-repair-mysql-database-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Repair MySQL Database Tables."}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=6510"}],"version-history":[{"count":2,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6510\/revisions"}],"predecessor-version":[{"id":7409,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6510\/revisions\/7409"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=6510"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=6510"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=6510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}