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 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 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 ...How to export from Blogger to WordPress
We can export the posts and comments from our Blogger blog to a cdmon hosting account where we have WordPress installed. To do this, once you have contracted a hosting service that includes PHP and MySQL, you will need to install WordPress manually ...How to disable a WordPress Plugin from phpmyadmin
If you need to deactivate a WordPress plugin but cannot do it from the WordPress admin panel, you can deactivate it through phpMyAdmin. Below is a detailed step-by-step guide on how to do it. Access phpMyAdmin Log in to your hosting control panel and ...