1. Log into your cPanel account.

2. In the Databases section, click on the phpMyAdmin icon.
phpmyadmin-icon.gif 3. In left side-bar, Click on the expand button to expand the database like "example".
phpmyadmin-expand-db.gif 4. Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to optimize.
phpmyadmin-db-list.gif 5. Scroll down and mark Check All then click on the Drop-down option and select Optimize tables.
optimize-db.gif Table successfully optimized.

Comments

Confirm Submission

Please enter the text from the image in the box provided; this helps us to prevent spam.