{"id":34178,"date":"2021-10-07T16:26:29","date_gmt":"2021-10-07T16:26:29","guid":{"rendered":"https:\/\/www.hostduplex.com\/kb\/?post_type=ht_kb&#038;p=34178"},"modified":"2021-10-07T16:31:36","modified_gmt":"2021-10-07T16:31:36","slug":"how-to-repair-mysql-databases-using-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/www.hostduplex.com\/kb\/article\/how-to-repair-mysql-databases-using-cpanel\/","title":{"rendered":"How to repair MySQL databases using cPanel"},"content":{"rendered":"\n<p>As a database&#8217;s tables grow, errors may occur from time to time. When they do, MySQL and cPanel include tools that you can use to check and repair your database.<\/p>\n\n\n\n<p>1. Log in to your cPanel acccount<\/p>\n\n\n\n<p>2. Click on MySQL Databases. You can use the search bar or scroll down to the Databases section to find it<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"344\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-1024x344.png\" alt=\"\" class=\"wp-image-34180\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-1024x344.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-300x101.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-768x258.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-50x17.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-1536x517.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-2048x689.png 2048w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-60x20.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.00.57-AM-100x34.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Scroll down to the Modify Databases section. Once there, select the database you want to repair and click on the &#8220;Repair Database&#8221; button<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"340\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-1024x340.png\" alt=\"\" class=\"wp-image-34181\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-1024x340.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-300x100.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-768x255.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-50x17.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-1536x510.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-60x20.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM-100x33.png 100w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.34-AM.png 1756w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. The repair process will begin automatically. Wait until you see a &#8220;Repair Complete!&#8221; message<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"276\" src=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-1024x276.png\" alt=\"\" class=\"wp-image-34182\" srcset=\"https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-1024x276.png 1024w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-300x81.png 300w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-768x207.png 768w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-50x13.png 50w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-1536x414.png 1536w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-2048x552.png 2048w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-60x16.png 60w, https:\/\/www.hostduplex.com\/kb\/wp-content\/uploads\/2021\/10\/Screen-Shot-2021-10-07-at-11.01.44-AM-100x27.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Great! You have succesfully repaired a MySQL database<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As a database&#8217;s tables grow, errors may occur from time to time. When they do, MySQL and cPanel include tools that you can use to check and repair your database. 1. Log in to your cPanel acccount 2. Click on MySQL Databases. You can use the search bar or scroll&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[20],"ht-kb-tag":[],"class_list":["post-34178","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=34178"}],"version-history":[{"count":4,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34178\/revisions"}],"predecessor-version":[{"id":34192,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34178\/revisions\/34192"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=34178"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=34178"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=34178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}