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.