How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.

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

3. Click on the Expand icon from the navigation tree in the left sidebar.
phpMyAdmin navigation tree

4. Scroll down and mark Check All. Click on the drop-down option and select Optimize tables.
check all table

The table has been successfully optimized.

Was this answer helpful?

Related Articles

How to Repair a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.3. Click...

How to Export Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the...

How to Import a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the...

How to Rename a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3....

Creating a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases.  3. In...