How do I repair a WHM database?

Repairing a database in WHM (Web Host Manager) is essential for maintaining the integrity and performance of your MySQL databases. This guide will walk you through the steps to repair a database using WHM.

Step 1: Log into WHM

1. Open your web browser and navigate to https://your-server-IP:2087.
2. Enter your WHM root username and password to log in.

Step 2: Access MySQL Databases

1. In the left sidebar, scroll down to SQL Services.
2. Click on MySQL Databases.

Step 3: Select the Database

1. You will see a list of existing databases. Identify the database you wish to repair.
2. Make a note of the database name, as you will need it for the repair command.

Step 4: Repair the Database via Command Line (SSH)

Since WHM does not provide a direct interface for repairing databases, you'll need to use SSH to run the repair command.

1. Connect to Your Server via SSH:
• Use an SSH client (like PuTTY) or terminal.

Connect to your server:
bash
Copy code
ssh root@your-server-IP

1. Access MySQL Command Line:

Once logged in, enter the MySQL command line:
bash
Copy code
mysql -u root -p

• Enter your MySQL root password when prompted.

1. Use the REPAIR TABLE Command:

Select the database you want to repair:
sql
Copy code
USE your_database_name;

Repair the specific table(s) within the database:
sql
Copy code
REPAIR TABLE your_table_name;

If you need to repair all tables, you can use:

• Followed by repairing each table individually.

1. Exit MySQL:
• Type exit; to leave the MySQL command line.

Step 5: Verify the Repair

1. Log into WHM again.
2. Check the MySQL Databases section to ensure that the database is functioning correctly and that there are no errors.

Additional Tips

• Backup Your Data: Always create a backup of your database before performing repairs.
• Monitor Performance: After the repair, monitor the database performance to ensure that issues have been resolved.

Summary

Repairing a database in WHM involves accessing the MySQL command line via SSH and using the REPAIR TABLE command for specific tables. Regular maintenance and backups are crucial to prevent database issues in the future. If you encounter persistent problems, consider seeking assistance from your hosting provider or a database administrator.