How to optimize a MySQL database via phpMyAdmin in cPanel?

1. Log into your cPanel account.

2. In the "Databases" section, click on "phpMyAdmin" Icon.

 

 

3. In left side-bar, Click on the expand button to expand the database like "example".

 

 

4. Under your cPanel username, you can see a list of all the databases. Select the appropriate database which you want to optimize.

 

 

5. Scroll down and mark "Check All" then click on the Drop-down option and select "Optimize tables".

 

 

Table successfully optimized.

Was this answer helpful? 0 Users Found This Useful (0 Votes)