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

→ Looking to repair a MySQL Database through Linux and Windows command line? Please refer to repair MySQL database for more details.

→ Looking to administrate MySQL server through MySQLAdmin commands? Please refer to fix administrate MySQL using commands for more details.

→ Want to take MySQL Database backup using command line? Please refer to take MySQL database backup for more details.

→ Looking to increase Max_User_connection for MySQL in Linux? Please refer to increase max_user_connection for more details.

Related Articles

Default Files and Folders in cPanel Account

While we create new account in cPanel, you may find following default files and folders:...

Why am I Unable to Access Website, cPanel and Webmail?

It may have happened because of multiple failed login attempts. In order to prevent brute force...

What is the maximum number of email disk space I can allocate to a single email account in a Linux shared hosting account?

There is no such limit to allocate the email space for the single email account in Linux shared...

Do you allow port scanning in any hosting plans?

No, we do not allow port scanning in any of our Web Hosting plans. Get Windows Shared Hosting

Password Policy For Shared Hosting Email Accounts

Linux Shared Hosting cPanel/WHM enables admins to define the minimum password strength for all...

  • 0 Users Found This Useful

Was this answer helpful?