How to free up space from a database
A database is a tool used to collect and organize information. Databases can store information about people, products, orders, or other items.
cdmon databases are MySQL. MySQL is based on a client-server model. The core of MySQL is the MySQL server, which handles all database instructions (or commands). The MySQL server is available as a standalone program for use in a client-server network environment (phpMyAdmin).
All the content of the website stored in the database is not deleted unless explicit actions are taken to remove that content from the database. The issue is that if it is not deleted, the database will continue storing all data since its creation, and database space is not unlimited. Therefore, if the storage limit is exceeded, the website associated with this database will not be able to continue storing content.
In this guide, we will show how to free up space in a cdmon database using phpMyAdmin.
How to view the list of hosting databases
To view the created databases, simply go to Databases and click on the MySQL icon.
You must go to MySQL database list, where you will be able to see all the created databases and the space used by each one.
How to free space in a database
The MySQL access details can be found in the summary at the beginning of the hosting management screen, under Hosting information.
Once you have the MySQL username and password, you will be able to access phpMyAdmin from the Access databases (phpMyAdmin) icon in the "Databases" section.
When you click the Access databases (phpMyAdmin) option, you will reach the following screen, where you will be asked for the MySQL user, MySQL password, and for security reasons you must also enter the Captcha. Once the information is entered correctly, you will access phpMyAdmin.
Once inside phpMyAdmin, you must select the database you want to manage:
Next, all the tables contained in the selected database will be displayed.
To see which tables take up the most space, you only need to filter the tables by size. To do this, go to the values of all tables and click on Size as shown in the image:
This way you can filter all tables from largest to smallest by size, allowing you to easily identify the ones using the most space.
Next, you only need to delete content from the table you want to clean up. You can either delete the entire table or access it and remove specific data.
To delete, simply select the table in question and click on Delete.
IMPORTANT: Keep in mind the initial explanation, meaning that the content of the database consists of data and information about your website. Before deleting anything, we recommend reviewing and verifying that the table you intend to remove is the correct one, as it may directly affect your website.
Related Articles
How to connect to a database with MySQL Workbench
Below we explain step by step how to establish a connection to your MySQL database using MySQL Workbench, including the necessary screenshots to guide you during the process. 1. Download and installation of MySQL Workbench MySQL Workbench is a free ...Staging: create test environments without affecting your main website
The tool ofStaging(or test environment) allows you to create afunctional copy of your websitein an isolated environment. It is ideal for doingtests, apply updates or make changeswithout affecting your main website. Enter the control panel Access the ...How to enable alerts for lack of disk space
Low disk space alerts allow you to receive notifications when your hosting account is running out of space to store additional content. To activate these alerts, you must access the hosting management section in the cdmon control panel, and under the ...Pilotron | Database management in cdmon
Pilotron is your artificial intelligence assistant in the cdmon control panel. With this tool, you can manage and obtain information about your databases quickly and easily, without needing to manually navigate through the control panel. In this ...How to delete a database
In some cases it is necessary to delete the database that we have in the hosting in order to create a new one, or because the contracted plan only allows a maximum of 1 and we need to remove the current one. In this guide we will show how to delete ...