Knowledge Base
MilesWeb / Database

Learn To Repair And Optimize MySQL Database using phpMyAdmin

Approx. read time : 3 min

Optimize MySQL Databases.

Databases can grow to very large space, particularly for the sites that receive huge traffic and contain a large amount of content. Thus, optimizing databases after every particular time period helps to improve your website performance.

Follow the below steps to optimize a MySQL  database :

1. Log in to your cPanel account.

2. Go to the Databases section on the cPanel home screen and click on phpMyAdmin.

DB 1

Now you can see the phpMyAdmin administrator page appeared in a new window.

3. On the left-hand side, click on the name of the database file that you want to optimize.

For example, the below image shows the example_wordpress database is been selected.

DB 2

4. In the right-hand side of the panel, select the check boxes for the tables in the database that you wish to optimize.

Tip: If you want to select all the tables at once, select the Check All checkbox.

 

DB 3

5. In the drop-down list box of With Selected, select the Optimize table. The phpMyAdmin will inform you whether or not your optimization process is successful.

Steps to Repair MySQL databases –

Your databases can get corrupted due to the number of reasons, like software defects, hardware issues, or even due to natural calamities. In such condition, you can repair database tables using phpMyAdmin.

To repair MySQL database, follow the below steps :

1. Log in to cPanel account.

2. Go to the Databases section on the cPanel home screen and click on phpMyAdmin.

3. On the left-hand side of the panel, click on the name of the database that you want to repair.

For example : image shows that example_wordpress database is selected :

DB 4

4. In the right-hand side of the panel, check the boxes of the tables for those you want to perform repair task.

DB 5

Note: You can select all the databases at once, by selecting the Check All checkbox.

5. In the drop-down list box of With Selected, select Repair table. The phpMyAdmin will inform you whether or not your repair process is successful.

That’s it!

You are done.

Also Read :

1. How to import MySQL tables using phpMyAdmin?

2. How to Backup an SQL Server Database?

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.