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.
1.- Export a database
This option is useful when you want to migrate a hosting and need to import the database to a new server or simply keep a backup copy.
- Access phpMyAdmin:
- Log in with your credentials to phpMyAdmin.
- Select the database:
- Choose the database you want to export.
- Export:
- Click on Export.
- Export options:
- Quick: Exports the database with minimal configuration in a single click. Click Continue.
- Custom: Allows you to select specific tables, change the "File character set" (for example, UTF-8), apply compression to the file or modify the export format, among other options.
Once the file is downloaded, you will have the database copy saved on your disk, ready to be imported.
2.-Import a database
To import a database, you will need the file previously exported in formats such as .sql, .zip, .tar.gz or .tgz. You will also need to have a database created in the hosting (How to create a database in cdmon)
- Size limits:
- If the file size is larger than 30 MB, you must import it from the cdmon Control Panel. (How to import MySQL databases from the Control Panel)
- If it is smaller than 30 MB, you can import it directly from phpMyAdmin.
- Select the database:
- Choose the database where you want to import the file.
- Import file:
- Select the database and click the Import link.
- Upload the file:
- In the import window, click Select file and choose the file from your hard drive.
- In the File character set option, select the same encoding used during export, usually UTF-8.
- Finish the import:
- Click Continue and wait for the file to upload.
Related links
For more information, you can contact us.
Related Articles
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 ...How to export and/or import a WordPress backup
Sometimes we would like to have a backup copy of our WordPress installation in a simple and quick way to avoid data loss, server issues, moving installations, updates, etc. To create a backup of our blog, we have the WordPress "Export/Import" tool ...How to access phpMyAdmin
If you want to view, modify or delete data from your database, the best option is to access it through phpMyAdmin. phpMyAdmin is a database manager accessible through an Internet browser. You can access it through the hosting Control Panel. To do so, ...How to generate a website backup to other providers
If you are migrating to cdmon from another provider, you will need to generate a backup of your current website so that you can import it into your new cdmon hosting. If you wish to move your website to cdmon on your own, in this guide we will ...How to change the check of a database from phpMyAdmin
The collation of a database is a crucial aspect to ensure that data is stored efficiently and accurately. In this article, we will show you how to change the collation of a database using phpMyAdmin. Before showing the steps to make this change, it ...