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 access credentials.

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:

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.

Where to find the database connection data (MySQL)

How to modify the associated WordPress domain from the database

For more information, you can contact us.