{"id":455,"date":"2017-02-19T14:40:34","date_gmt":"2017-02-19T14:40:34","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&p=455"},"modified":"2020-03-25T14:42:29","modified_gmt":"2020-03-25T14:42:29","slug":"how-to-check-or-repair-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/how-to-check-or-repair-mysql-database\/","title":{"rendered":"How to Check or Repair a MySQL Database?"},"content":{"rendered":"

In this article, we will show you how to check for error or repair a MySQL database through cPanel or phpMyadmin. This can easily be done by following the steps listed in this step by step article.<\/p>\n

Though cPanel<\/h3>\n

1)<\/strong>\u00a0Log into cPanel<\/a><\/strong>.<\/p>\n

2)<\/strong> Look for the “DATABASES<\/strong>” section and click on\u00a0“MySQL\u00ae Databases”<\/strong>.<\/p>\n

 <\/p>\n

\"\"<\/a>
cPanel > Databases > MySQL\u00ae Databases<\/figcaption><\/figure>\n

3)<\/strong> Look for the\u00a0“Modify Databases”<\/strong>\u00a0section, here you can either check for errors or repair\u00a0a\u00a0MySQL database. Select the database you want to check<\/strong> from the drop down menu and click on the “Check Database<\/strong>” button.<\/p>\n

To repair<\/strong> a corrupted database\u00a0just the database you want to check from the drop down menu and click on the “Repair Database<\/strong>” button.<\/p>\n

 <\/p>\n

\"\"<\/a>
Modify Databases > Check or Repair database<\/figcaption><\/figure>\n

A new interface will appear\u00a0and the system will attempt to automatically check\/repair the database.\u00a0If the system cannot repair the database, it will attempt to determine the source of the corrupt data.<\/p>\n

That’s it! Now you know how to check or repair database tables through cPanel.<\/p>\n

Through phpMyAdmin<\/h3>\n

1)<\/strong>\u00a0Log into cPanel<\/a>.<\/p>\n

2)<\/strong> Look for the “DATABASES”<\/strong>\u00a0section and click on “phpMyAdmin”. You’ll be redirected to the\u00a0phpMyAdmin interface.<\/p>\n

\"\"<\/a>
cPanel > Databases > phpMyAdmin<\/figcaption><\/figure>\n

3)<\/strong> From this new screen, we\u00a0have direct access to all the databases created under this cPanel account, they are all listed on the left side.<\/p>\n

\"\"<\/a>
phpMyAdmin interface<\/figcaption><\/figure>\n

4)<\/strong> Select the database you wish to check or repair.<\/p>\n

5)<\/strong> You will now see all the database’s tables. Select the table(s) you wish to check or repair, or simply click Check All<\/strong>\u00a0to select all tables.<\/p>\n

\"\"<\/a>
Select database > Tick ‘Check All]’ to select all tables<\/figcaption><\/figure>\n

6)<\/strong> Click the drop-down With selected:\u00a0<\/strong>]and choose Check table<\/strong> or\u00a0<\/em>Repair<\/em> table<\/em><\/strong>. This will execute the CHECK\/<\/em>REPAIR TABLE<\/em> SQL query on the selected tables and they will be checked or repaired.<\/p>\n

\"\"<\/a>
Click the drop-down With selected: and choose Check table or Repair table<\/figcaption><\/figure>\n

That’s it! Now you know how to check or repair database tables through phpMyAdmin.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

In this article, we will show you how to check for error or repair a MySQL database through cPanel or phpMyadmin. This can easily be done by following the steps listed in this step by step article. Though cPanel 1)\u00a0Log into cPanel. 2) Look for the “DATABASES” section and click…<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[],"class_list":["post-455","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=455"}],"version-history":[{"count":3,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/455\/revisions"}],"predecessor-version":[{"id":2121,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/455\/revisions\/2121"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=455"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=455"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}