How to export / import database using phpMyAdmin

This post is about how to copy a SQL database from one machine to another using phpMyadmin.

Exporting the database

1. Login to phpMyAdmin of the machine with the SQL database to be exported. Left click on the database to be exported, then left click on Export.

In this case, the database to be exported is called "THC".

2. Click "Go".

The database is exported and saved as "THC.sql" to the local computer.

Importing the database

1. Login to phpMyAdmin of the machine that will received the exported "THC" database.

2. Create an empty database by left click on New.

Give the new database a name. In this case, it's "THC".

Click "Create".

3. Select the newly created database, then left click on Import.

Left click on "Choose File" to pick the exported "THC" database.

4. Scroll down to click on "Go" to import the database.

5. The database is now copied to a different machine.