1. Log into your cPanel account.

2. In the Databases section, open the app installer by clicking on the phpMyAdmin icon.
How to optimize the database via phpMyAdmin in cPanel? - phpmyadmin icon


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

 

 

 

 

 

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

5. Scroll down and mark Check All then click on the Drop-down option and select Optimize tables.
How to optimize the database via phpMyAdmin in cPanel? - optimize db

Table successfully optimized.

Posted by in Databases on September 18, 2016 |







Included with Our Plans

We include the following with all orders

  • 24/7 live chat & email support
  • cPanel based web hosting
  • Softaculous – the best script installer
  • Easy, automated upgrades with our shared hosting
  • Unlimited email address
  • Fast and reliable servers
  • Free Website Migration