How to import MySQL databases from Control Panel
In the cdmon Control Panel you can execute SQL scripts that allow you to import MySQL data into databases directly on the MySQL server. You can find the tool in the hosting Control Panel.
To execute a MySQL script, first upload it via FTP to the "/backup_db" folder that you will find in the root of the hosting, at the same level as the "/web" folder.
Once the script has been uploaded, you can proceed with its execution. To do so, access the hosting management and click on the MySQL option in the "Databases" section.
Once inside, you will find the management menu called "SQL script execution", where you must fill in several fields.
The fields to fill in refer to the following:
- Database: select the destination database that you have previously created.
- Encoding: you can select UTF8 or LATIN1, depending on the encoding of the server it comes from.
- File: the name of the file you want to load into the database.
Once the fields are completed, click Execute to start the process.
When the process finishes, you will receive an email indicating whether the execution was completed successfully.
Related links
For more information, you can contact us.
Related Articles
How to import and export databases from phpMyAdmin
From phpMyAdmin you can manage your databases, add, delete, or create new content. Two of the most common operations when using phpMyAdmin are importing and exporting databases. First access phpMyAdmin (application used to manage databases) using the ...How to import CSV files to MySQL from PHP and SSH
cdmon ensures the security and proper operation of its services. For this reason, certain insecure MySQL functionalities for loading local files in bulk are not available. Below we explain three methods to import data into MySQL. 1.-Import a CSV file ...How to create MySQL databases
The use of dynamic pages or content management systems requires the use of MySQL databases. These databases can be created from the cdmon control panel. To create a database, first access the hosting management section. Once you access the hosting ...How to import a database by SSH
Before starting, it is important to mention that not all hosting plans provide SSH access. To follow this guide, you will need a plan that includes this feature. The available plans are the Senior plans or higher. You can check our comparison table ...Where to view MySQL connection data
Many of the applications that you can install on your website require databases and, in order to connect to them and use them, you need the MySQL connection details. You can find this information in the hosting management panel. Within the hosting ...