Wesbytes Knowledge Base

Search our articles or browse by category below

How to Reduce the size of a MySQL database

Last modified: June 28, 2022
You are here:
Estimated reading time: 1 min

Reduce the size of a MySQL database

You can verify your database content and minimise its size by eliminating some unnecessary data if a database on your account has reached (or is about to approach) the database size limitation.

To do so go to cPanel -> phpMyAdmin, and select the database in question from the left sidebar.

When the page loads you will see all database tables listed on your screen. Locate the Size column and click on it. This will sort all the tables by size, listing the largest tables at the top of the page.

Then determine whether it is safe to delete the data from the biggest tables by reviewing its contents. For instance, you can remove the tables that house logs and transient data. Please make sure that any data you wish to remove is not necessary for the operation of your website before doing so. Create a database backup as well so you can easily restore it if you accidentally erase any crucial data.

If you exceed the MySQL Database size limit and you want to keep all of the data in the database for your website, you can consider an upgrade to a higher plan where the MySQL Database size limit would suite your needs.

Was this article helpful?
Dislike 0
Views: 5