How to Repair MySQL Database from cPanel WHM and phpMyadmin

This article describes how to repair MySQL database using cPanel, WHM and phpMyAdmin.

Repair MySQL database through cPanel

  1. Log in to cPanel.
  2. Under Databases section of cPanel, click on MySQL Databases.

    MySQL Databases

  3. Under Modify Databases section, select the database from Repair a Database drop down and click on Repair the Database button.

    Modify Databases

    Repair Complete

Repair MySQL database through WHM

  1. Log in to WHM.
  2. Under SQL Services section, select Repair a MySQL database option.

    SQL Services

  3. Select the database you wish to repair from the list of all databases and click on Repair Database button.

    Mysql Databases

    Repair MySQL Host

Repair MySQL database through phpMyAdmin

If you have access to cPanel, follow below mentioned steps to repair MySQL database.

  1. Log in to cPanel.
  2. Under Databases section of the cPanel, click on phpMyAdmin. This will open phpMyAdmin administration page in new window.

    phpMyAdmin

  3. At left pane, click on database you wish to repair.

    Repair Table phpMyAdmin

  4. At right pane, select check boxes of the database table. If you want to repair all tables, select check all option.
  5. In the With selected list box, select Repair table.

    SQL Query Execution

If you have access to WHM, follow below mentioned steps to repair MySQL database.

  1. Log in to WHM.
  2. Under SQL Services section of the WHM, click on phpMyAdmin. This will open phpMyAdmin administration page in new window.

    phpMyAdmin

  3. At left pane, select and click on database you wish to repair.

    Repair MySQL Database Tables

  4. At right pane, select check boxes of the database table. If you want to repair all tables, select check all option.
  5. In the With selected list box, select Repair table.

    SQL Query Execution

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Install OpenCart via Softaculous?

This tutorial will assist you to install OpenCart in your website through Softaculous....

How do I change document root folder to some sub-folder using an .htaccess file?

By default the web-contents of your website will be loaded from public_html directory. If you...

A subdomain that I have created isn't working.

Please note that subdomain requires DNS propagation and it may take upto 24 hours. If DNS...

When I connect to FTP account through filezilla it always says certificate is unknown. What am I missing here?

This error is common because FTP service of our shared server is bound with server's Self-Signed...

MySQL : Access denied for user 'Mysql_dbuser'@'localhost' (using password: YES) in /home/cPanel_user/public_html/file path.php

You may face this error while using mysqli_connect function on your website. Cause : This may...