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.
How to optimize database via phpMyAdmin in cPanel?
Related Articles
What is the website backup policy?
Backup Policy: Full automatic backups are made depending on the hosting package. No guarantees...
How to configure remote MySQL access in cPanel?This article describes how to use cPanel to allow external hosts to access your MySQL databases....
[PLESK 11] How to Backup and Restore Microsoft SQL Server DatabaseThis article applies to PLESK 11 Following are the steps to Get backup and Restore the...
Plesk - How to Backup DatabasesWith Parallels Plesk Panel, you can back up and subsequently restore the databases, database...
How to add a user to a database and add privileges?1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...