McAfee Trusted Site

How to Optimize a Database in phpMyAdmin

How to Optimize a Database in phpMyAdmin

In this article, we will show you how to optimize a database in phpMyAdmin.

Log into your cPanel account.

In the “Databases” section, click on “phpMyAdmin” Icon.

phpMyAdmin Icon

3. In left side-bar, Click on the expand button to expand database like “example”.

phpMyAdmin expand/collapse

4. Under your cPanel username, you can see list of all databases. Select appropriate database which you want to optimize.

phpMyAdmin database list

5. Scroll down and mark “Check All” then click on the Drop-down option and select “Optimize tables“.

phpMyAdmin optimize table

Table successfully optimized.

Learn More at

Our commitment to excellent client support

If you are unable to find a solution to how to optimize a database in phpMyAdmin from our knowledgebase, our support team will gladly assist you.

Was this article helpful?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages