Skip to main content

How to Repair a MySQL Database in WHM

Repair a MySQL or MariaDB database directly from the WHM interface. This procedure is intended for server administrators to resolve table corruption or structural issues within a specific database.

Before you begin

You will need:

  • Root access to the WHM interface

  • The specific database name that requires repair

Repairing a MySQL database

  1. Log in to WHM.

  2. Navigate to SQL Services > MySQL Database Repair.

  3. Select the database you wish to repair from the list.

  4. Click the Repair button next to the selected database.

  5. Wait for the process to complete. The system will display a success message or a status update once the repair is finished.

Confirm the result

  • The database status will no longer indicate a "corrupt" or "error" state.

  • You will see a success message confirming the repair was completed.

If the repair fails or the database remains inaccessible

If the repair process fails or the database remains inaccessible after a successful repair message, the issue may be related to the underlying MySQL service or a severe level of corruption that requires a manual command-line repair.

  1. Check the MySQL service status in WHM under Tools > Restart Service.

  2. If the service is running but the database remains broken, contact Hostek support with the specific database name and the error message you are receiving.

Limitations

This tool is designed to fix common table corruption. If a database is severely corrupted or has been deleted, this tool cannot recover the lost data.

Did this answer your question?