How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.

2. In the Databases section, click on phpMyAdmin.
How to Optimize a Database via phpMyAdmin in cPanel - 2024

3. Click on the Expand icon from the navigation tree in the left sidebar.
How to Optimize a Database via phpMyAdmin in cPanel - 2024

4. Scroll down and mark Check All. Click on the drop-down option and select Optimize tables.How to Optimize a Database via phpMyAdmin in cPanel - 2024


The table has been successfully optimized.