How to Import/Export a MySQL database using phpMyAdmin

Exporting Your Database

Follow these steps.

  1. Open phpMyAdmin.
  2. Click the name of the database to export in the list down the left side. The page will refresh and show information about the selected database.
  3. Click the “Export” tab. The page will refresh and show export options.
  4. In the “Export” group, the “MySQL” option should be selected if it is not selected already.
  5. In the “SQL Options” section, click the checkboxes beside both “Structure” and “Data”.
  6. Click the “Save as file” checkbox at the bottom of the options.
  7. Click the “Go” button.

You will be prompted by your Internet browser to save the file on your own hard drive. Select a location you can easily remember.

Once the download is complete, you will have a copy of your database on your own computer.

Importing Your Database

This assumes you have a new (but empty) database already created on the server. If you are importing to your Nuagerie account, click here to view an article with instructions on how to create a new database. You must do this in order to have a database to select as the destination for the imported data.

Follow these steps:

  1. Open phpMyAdmin.
  2. Click the name of the database which will be receiving the imported information. The page will refresh and show information about the selected database.
  3. Click the “Import” tab.
  4. Click the “Browse” button in the “File to import” section.
  5. You will be prompted by your browser to locate the database file on your own computer.
  6. Once the database file has been located and selected, the “Location of the text file” field will populate with the path to the database file. Click the “Go” button.

Once the file finishes uploaded, the data and structure it contains will be immediately available for use in the database.


If you still have questions about exporting or importing databases, please contact us with a new support ticket or our live chat feature.

  • cPanel, MySQL, server, serveur, base de données, database
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

 How to empty my DNS cache

Overview Your DNS cache stores the locations (IP addresses) of web servers that contain web...

 What is cPanel?

cPanel is a control panel with which you can manage almost any element of your cPanel hosting...

 How cPanel & WHM Improved Email Hosting

cPanel and WHM have gone through some serious upgrades to their Email Hosting features...

 CURL: could not resolve host: cpanel.net

Error: curl: (6) Could not resolve host: securedownloads.cpanel.net; Unknown error Fix:...

 How can I activate my paid license after a trial?

You can do this by running this command in SSH: /usr/local/cpanel/cpkeyclt It should...