How to optimize database via phpMyAdmin in cPanel?

1. Log into your cPanel account.

2. In the “Databases” section, click on the “phpMyAdmin” Icon.
optimize database via phpMyAdmin in cPanel-websiteroof

3. In the left side-bar, Click on the expand button to expand the database like “example”.optimize database via phpMyAdmin in cPanel-websiteroof

 

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

5. Scroll down and mark “Check All” then click on the Drop-down option and select “Optimize tables“.
optimize database via phpMyAdmin in cPanel-websiteroof

Table successfully optimized.

Customers' reviews on Hostings.info Website Roof is listed on whtop.com Website Planet IPV6 Supported Secured by Imunify360