Export and import MySQL databases using phpMyAdmin

You can use phpMyAdmin to import and export your database, as long as it is relatively small (10MB or less). If your database is larger than 10MB, Please skip to Method 2 - command line.

First, log into phpMyAdmin :
Once you're logged into phpMyAdmin, follow the steps outlined below :

Export

In phpMyAdmin, select your database from the list on the left :

 

 Click on Export from the top set of tabs.

 

Click the radio button for "Custom" to view all available options. Select the tables from the list that you would like to back up. If you want to back up the entire database, click Select All.  

By default, your database name will be used to name the exported database file. You can change this by entering your desired file name in the File name template box. You can also select a compression option (such as "gzipped") if you want to compress the backup before downloading it from the server. 

  

Make sure radio button for "structure and data" is selected from the "Dump Table" option list. This should be the default setting.

In the Structure section, check the box for "Add DROP TABLE / DROP VIEW / PROCEDURE / FUNCTION / EVENT statement" if you want this export to be able to replace existing tables of the same name. If you want to merge this backup with another database, do not select this.

 

Click the Go button to save the file to your local computer. 

Import

Make sure the database you need has already been created. If it has not, please first create the database

CAUTION:
If you import a backup file to a database that already has content, it will replace the existing content.

In phpMyAdmin, select your database from the list on the left.

Click on "Import" from the top set of tabs. 

Click on the "Choose File" button.

Browse to your local SQL file and click "Open." If it is a zipped file, be sure to unzip the file first.
Click the "Go" button towards the bottom of the page. Wait while your database imports. Depending on the size, this can take a few minutes.

You should get a message like this:

"Import has been successfully finished, X queries executed."