How to optimize database via phpMyAdmin in cPanel?

How to optimize 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 database like "example".












4. Under your cPanel username, you can see list of all databases. Select 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.
  • Database, phpMyAdmin, cPanel
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to generate a cPanel backup and send to FTP Server?

How to generate a cPanel backup and sent to FTP Server? 1. Log into your cPanel account.2....

How to generate and download a full backup of your cPanel Account?

How to generate and download a full backup of your cPanel Account? 1. Log into your cPanel...

How to upload files via the cPanel FileManager?

How to upload files via the cPanel FileManager? If you don't want to use a 3rd party FTP...

How to Reset my cPanel Account Password?

How to Reset my cPanel Account Password? If you can access your cPanel account, follow these...

How to update your cPanel Contact Information or receive a notification on reaching quota limit?

How to update your cPanel Contact Information or receive a notification on reaching quota...