Database - Reduce / Optimise Table Size

  Print

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 in to cPanel and click on phpMyAdmin

d78eed727e4570bc3f777003ad1776395e837fb5?t=7b13ad93398d875195ea78fca5e1272c


Step 2 - Click on the Database you want to optimise

3e02b7ee6c938e2291e099910f04b887c3c60893?t=b7eb3fd5d0234e155e881581c58d79c4


Step 3 - (1) click Check all then (2) select Analyze Table

217860b2108a2209eed4e179cb880ebff29b86ba?t=dfa496c3a0ba8bfaf6972a36aef46e24


Step 4 - Once the Analyze table function is complete, scroll down, and (1) click Check all then (2) select Optimize Table


a73d5fb517d9e689e43bd028a58348a09ddebd6e?t=7038f1837c4446a60e280bbb5d8b7c7e


Step 5 - Once the Optimize table function is complete, scroll down, and (1) click Check all then (2) select Repair Table


955ab787e671ec34d38287f60705cbc1fce53f7b?t=0eaf6bbce19902d2eaf346ed1a45d1a3



Related Articles