{"id":33690,"date":"2016-09-18T17:07:35","date_gmt":"2016-09-18T17:07:35","guid":{"rendered":"https:\/\/hostduplex.com\/kb\/?p=51"},"modified":"2016-09-18T17:07:35","modified_gmt":"2016-09-18T17:07:35","slug":"how-to-repair-database-via-phpmyadmin-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.hostduplex.com\/kb\/how-to-repair-database-via-phpmyadmin-in-cpanel\/","title":{"rendered":"How to Repair database via phpMyAdmin in cPanel?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><strong>1.<\/strong> Log into your cPanel account.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Databases<\/strong> section, click on the <\/span><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>phpMyAdmin<\/strong><\/span><\/span> icon.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-icon.gif\" alt=\"\" align=\"middle\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>3.<\/strong> In the left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-expand-db.gif\" alt=\"\" align=\"left\" \/><\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>4.<\/strong> Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to repair.<\/span><\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-db-list.gif\" alt=\"\" \/><br \/>\n<\/span><br \/>\n<span style=\"font-size: medium;\"><strong>5. <\/strong>Scroll down and mark <\/span><span style=\"font-size: medium;\"><strong>Check All<\/strong> then click on the Drop-down option and select <strong>Repair table<\/strong>.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/repair-db.gif\" alt=\"\" \/><\/span><\/p>\n<p>If the table successfully repaired, then it will show an <strong>Ok<\/strong> message; otherwise, it will show some error on a few tables like &#8220;<strong>Error unknown engine&#8221; <\/strong>related errors.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In the left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4. Under your cPanel username, you can see a list of all databases&#8230;.<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-33690","post","type-post","status-publish","format-standard","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=33690"}],"version-history":[{"count":0,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33690\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=33690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/categories?post=33690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/tags?post=33690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}