How to Optimize a Database via phpMyAdmin in cPanel

How to Optimize a Database via phpMyAdmin in cPanel

  1. Log into your cPanel account.

  2. In the Databases section, click on the phpMyAdmin icon.

    image

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

    image

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

    image

  5. Scroll down and mark Check All then click on the drop-down option and select Optimize Tables.

    image

Your table is now successfully optimized.