How to Reduce / Optimise A Database Table Size in cPanel
Optimising and reducing the size of your database is a great way to help speed your website up and reduce clutter in the database.
Step 1 - Log into cPanel and click on phpMyAdmin.
Step 2 - Click on the Database you want to optimise.
Step 3 - (1) click Check all then (2) select Analyze Table.
Step 4 - Once the Analyze table function is complete, scroll down, and (1) click Check all then (2) select Optimize Table.
Step 5 - Once the Optimize table function is complete, scroll down, and (1) click Check all then (2) select Repair Table.
