From phpMyAdmin you can manage your databases, you can add, delete or create new content.
Two of the most common operations when using phpMyAdmin is importing and exporting databases.
1.- Export database
Use this option when you want to migrate a host and need to import the databases to the new host or simply to save a backup.
First access the phpMyAdmin with the access data.
Once inside phpMyAdmin, select the database that you want to export to a file.
When selecting the database, click on Export.
A new window appears with the two options to export the database:
- Quick: shows only minimal options and allows one-click export by clicking Go.
- Custom: allows you to select the tables you want to export, modify the "Character set of the file" UTF-8, select compression, if you want the generated file to take up less space or the file format, among other options.
Once the file is downloaded, you already have the copy of the database on your disk, ready to import.
2.- Import database
To import a database you need the previously generated file with the data. If you are migrating a database from another host to cdmon, you must have a copy of the database in a file with a .sql, .zip, .tar.gz or .tgz extension on your computer's hard drive.
If the database to be imported is more than 30 MB you have to carry out the import through the cdmon Control Panel. If the database is less than 30 MB you can do it from the same phpMyAdmin.
First, choose the database to which you want to import the file. You can also create it through the cdmon Control Panel.
Once inside phpmyadmin, select the database you have created to which you want to import the file.
Click the Import link.
Displays the window where it allows you to browse and search for the database file. Click on Seleccionar archivo, select the file and accept.
In the selection of "Character set of the file" you have to select the same option that you chose when you exported the database. UTF-8 is commonly used.
Once this is done, all you have to do is click Go and wait for the file to load. It will take more or less, depending on the size of the file.
For more information, you can contact us.