Experiencing issues with your database? This guide outlines three methods for repairing a MySQL database using cPanel, WHM, or phpMyAdmin. Choose the approach that best fits your comfort level and restore your database to optimal condition.

How to do it

Method 1: Repair via cPanel

  1. Step 1: Access MySQL Databases

    Log in to your cPanel account and navigate to the "MySQL Databases" section.

  2. Step 2: Select the database

    Locate and select the database you want to repair from the list.

  3. Step 3: Repair the database

    Click on the "Repair Database" button to initiate the repair process.

Method 2: Repair via WHM

  1. Step 1: Access WHM

    Log in to WHM (Web Host Manager).

  2. Step 2: Find repair tool

    Use the search function to find "Repair a MySQL Database."

  3. Step 3: Repair the database

    Select the database from the list and click "Repair Database."

Method 3: Repair via phpMyAdmin

  1. Step 1: Access phpMyAdmin

    Log in to WHM and access phpMyAdmin from the interface.

  2. Step 2: Select tables

    Under the Databases tab, check the boxes next to the tables you want to repair.

  3. Step 3: Repair selected tables

    Expand the "With selected" drop-down menu and select the "Repair Table" option.