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.