How to Optimize a Database via phpMyAdmin in cPanel
- Log in to your cPanel account.
- In the Databases section, click on phpMyAdmin.
- Click on the Expand icon from the navigation tree in the left sidebar.
- Scroll down and mark Check All. Click on the drop-down option and select Optimize tables.
The table has been successfully optimized.