{"id":16656,"date":"2024-05-21T12:18:48","date_gmt":"2024-05-21T12:18:48","guid":{"rendered":"https:\/\/hostvento.com\/kb\/web-hosting\/how-to-repair-mysql-database-via-cpanel-whm-and-phpmyadmin\/"},"modified":"2024-06-17T03:28:23","modified_gmt":"2024-06-17T03:28:23","slug":"how-to-repair-mysql-database-via-cpanel-whm-and-phpmyadmin","status":"publish","type":"docs","link":"https:\/\/www.hostvento.com\/kb\/docs\/hosting-faqs\/how-to-repair-mysql-database-via-cpanel-whm-and-phpmyadmin\/","title":{"rendered":"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?"},"content":{"rendered":"\n<p>Your databases&#8217; tables and indexes may occasionally get destroyed or corrupted, in which case you would need to rebuild them. Making repairs to the database is a straightforward solution.<\/p>\n\n\n\n<p>Repair MySQL Database<\/p>\n\n\n\n<p>via cPanel<\/p>\n\n\n\n<p>via WHM<\/p>\n\n\n\n<p>via phpMyAdmin<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1RepairMySQLDB\">To Repair MySQL Database via cPanel<\/h2>\n\n\n\n<p>1. Log in to your cPanel account.<\/p>\n\n\n\n<p>2. Go to the&nbsp;<strong>DATABASES<\/strong>&nbsp;section and click on&nbsp;<strong>MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png\" alt=\"\" class=\"wp-image-10896\"\/><\/figure>\n<\/div>\n\n\n<p>3. Find the&nbsp;<strong>Modify Databases<\/strong>&nbsp;section and<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>select the database from the drop-down&nbsp;list of the&nbsp;<strong>Repair Database<\/strong>&nbsp;field.<\/li>\n\n\n\n<li>Click on&nbsp;the&nbsp;<strong>Repair Database<\/strong>&nbsp;button.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/cp_mod_db_repair_db.png\" alt=\"\" class=\"wp-image-12858\"\/><\/figure>\n<\/div>\n\n\n<p>The cPanel will display the&nbsp;message:&nbsp;<em>Repair Complete!<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2RepairMySQLDB\">To Repair MySQL Database via WHM<\/h2>\n\n\n\n<p>1. Log in to the WHM panel with your root account.<\/p>\n\n\n\n<p>2. Select the&nbsp;<strong>SQL Services<\/strong>&nbsp;in the navigation menu.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png\" alt=\"\" class=\"wp-image-12859\"\/><\/figure>\n<\/div>\n\n\n<p>3. Click on&nbsp;<strong>Repair a MySQL Database<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_repair_mysql_db.png\" alt=\"\" class=\"wp-image-12860\"\/><\/figure>\n<\/div>\n\n\n<p>A list of databases will appear.<\/p>\n\n\n\n<p>4. Select the database you want to repair from the list and click the&nbsp;<strong>Repair Database<\/strong>&nbsp;button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_repair_mysql_db_sel_db.png\" alt=\"\" class=\"wp-image-12861\"\/><\/figure>\n<\/div>\n\n\n<p>It will take a while for the system to complete the process, depending on the database. After repairing the database, the system will show a success message:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_db_repair_success.png\" alt=\"\" class=\"wp-image-12862\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"3RepairMySQLDB\">To Repair MySQL Database via phpMyAdmin<\/h2>\n\n\n\n<p>Users can access phpMyAdmin via cPanel and WHM interfaces.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">To Open phpMyAdmin from cPanel<\/h3>\n\n\n\n<p>1. Log in to your cPanel account.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2020\/11\/phpmyadmin-min.png\" alt=\"\" class=\"wp-image-9380\"\/><\/figure>\n<\/div>\n\n\n<p>2. Scroll to the&nbsp;<strong>DATABASES<\/strong>&nbsp;section and click on&nbsp;<strong>phpMyAdmin<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">To Open phpMyAdmin from WHM<\/h3>\n\n\n\n<p>1. Log in to the WHM panel with&nbsp;your root account.<\/p>\n\n\n\n<p>2. Select the&nbsp;<strong>SQL Services<\/strong>&nbsp;in the navigation menu.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png\" alt=\"\" class=\"wp-image-12859\"\/><\/figure>\n<\/div>\n\n\n<p>3. Click on&nbsp;<strong>phpMyAdmin<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_phpmyadmin.png\" alt=\"\" class=\"wp-image-12863\"\/><\/figure>\n<\/div>\n\n\n<p>Once you have opened the phpMyAdmin module, you can follow these steps to repair a database.<\/p>\n\n\n\n<p>1. Click the&nbsp;<strong>Databases<\/strong>&nbsp;tab and&nbsp;select a database from the list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/phpmyadmin_select_db.jpg\" alt=\"\" class=\"wp-image-12864\"\/><\/figure>\n<\/div>\n\n\n<p>A list of tables of the database will appear.<\/p>\n\n\n\n<p>2. Tick the&nbsp;<strong>Check all<\/strong>&nbsp;box to select all tables of the database.<\/p>\n\n\n\n<p>There is a field with a list box beside it saying-&nbsp;<em><strong>With selected:<\/strong><\/em><\/p>\n\n\n\n<p>3. Open the list and click the&nbsp;<strong>Repair table<\/strong>&nbsp;option.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/phpmyadmin_repair_db.jpg\" alt=\"\" class=\"wp-image-12866\"\/><\/figure>\n<\/div>\n\n\n<p>The phpMyAdmin will execute the query for the database tables. After some time, a success message along with a brief report will appear indicating the database tables have been repaired.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.hostvento.com\/kb\/hosting-faqs\/wp-content\/uploads\/2021\/09\/phpmyadmin_repair_success.png\" alt=\"\" class=\"wp-image-12869\"\/><\/figure>\n<\/div>\n\n\n<p><strong>Warning<\/strong>: In some cases, repair operation on a database may cause data loss. As a precaution, we recommend you take a backup of the database before performing a repair operation.<\/p>\n\n\n\n<p><a href=\"https:\/\/hostvento.com\/kb\/web-hosting\/how-to-install-configure-postgresql\/\" target=\"_blank\" rel=\"noopener\"><strong>How To Install &amp; Configure PostgreSQL?<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your databases&#8217; tables and indexes may occasionally get destroyed or corrupted, in which case you would need to rebuild them. Making repairs to the database is a straightforward solution. Repair MySQL Database via cPanel via WHM via phpMyAdmin To Repair MySQL Database via cPanel 1. Log in to your cPanel account. 2. Go to the&nbsp;DATABASES&nbsp;section [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23377,"menu_order":374,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-16656","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/comments?post=16656"}],"version-history":[{"count":2,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16656\/revisions"}],"predecessor-version":[{"id":21224,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16656\/revisions\/21224"}],"up":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/23377"}],"wp:attachment":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/media?parent=16656"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=16656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}