How do I optimize a database and its tables via phpMyAdmin?

Question

How do I optimize a database and its tables via phpMyAdmin?

Answer

phpMyAdmin offers a feature that allows a user to perform basic database optimization.

1. Access phpMyAdmin via WHM as root or cPanel as the user that owns the database.
2. Select the database name to optimize from the sidebar on the left.

3. At the bottom of the list of tables mark the checkbox next to "Check All".

   Note: If you have more tables than can fit on a single page, you will need to "Check All" on every page of tables to ensure the optimization gets applied to all tables.

4. To the right of that checkbox look for the dropdown menu and select Optimize Table.