How to import or export a MySQL database using phpMyAdmin

Export 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.

Your browser will prompt you to save the file on your computer. Choose a location that is easy to find.

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

Import your database

This assumes that a new, empty database has already been created on the server. If you are importing to your Nuagerie account, see our guide to creating a database in cPanel. You need this 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. Your browser will prompt you to locate the database file on your 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 uploading, the data and structure it contains will be immediately available for use in the database.

For help with a Nuagerie service, see our Support page. For general questions, see our Contact page.