How to Export and Import MySql Database using phpMyAdmin

Export and Import MySql Database is very easy any one can easily import and export it.

First let us see how to export database from phpMyAdmin

Export Mysql Database from phpMyAdmin

Follow these steps to export Mysql Database

How to import database in phpmyadmin xampp is same as below

First open your phpMyAdmin

Here I am using XAMPP server I have started XAMPP Apache and MySql Services.

Click on XAMPP MySql Admin it will open following page

You can open directly http://localhost/phpmyadmin if your server is running with Apache and MySql services.

phpMyAdmin Home page
phpMyAdmin Home Page

Select your database

On left hand side it shows list of all databases available in Mysql.

Select database to which to want to backup.

Here we are selecting testdb to export

phpMyAdmin Selecting database
Select Database

Go to Export tab

Go to export tab as shown in below image

phpMyAdmin Selecting Export tab
Go to export tab

Export the database by clicking on Go button

As you are now in export tab, below on this tab you will find Go button.

Above the Go button there are various format to export data.

Different export format is as below

How to export SQL in phpMyAdmin
phpMyAdmin Export Formats

We have selected SQL and click on go.

It will download database in testdb.sql file

phpMyAdmin selecting format and exporting database
Export the database by clicking on go button

Export Method can be used to download all of few tables from database.

Export method type custom can be used to select tables to download.

Importing Database in phpMyAdmin

Create a Database where you want to import database.

Here testdb1 is created to import tables

phpMyAdmin creating database
phpMyAdmin creating database

Go to Import Tab

After creating database go to import tab and select sql file.

As shown browse your computer and select file to import in database

phpMyAdmin importing database
Import data in phpMyAdmin

Click on Go

After selecting file scroll down you will find go button.

Click there it will start uploading database file

phpMyAdmin importing database
phpMyAdmin Uploading sql file

After successfully uploading tables it will show all tables in database.

Here testdb1 contains table uploded from testdb database

phpMyAdmin database list
phpMyAdmin database list in left sidebar

Checking table content in testdb1.

All data sucessfully imported to testdb1 from testdb database.

phpMyAdmin database content
phpMyAdmin table data

Import and Export mysql database command line

MySql Database Import and Export from Command Prompt

First access mysql(MariaDB) from command prompt as below

then type

It will ask for password.

By default it does not have any password so press enter

After login it will show all your databases.

to export database we use following command

mysqldump -u db_username -p database_name > path_where_to_save_sql_file

mysqldump -u root -p testdb > data.sql

To Import data from file we use followng command

Thats it.

We can easily take back up and restore data from file to database and database to file as per our requirement.

Here we have seen phpMyAdmin and command prompt based to import and export database

Read More:

  1. PHP MySQL CRUD Tutorial with MySqli and PHPMyAdmin
  2. How to fetch image from database in PHP and display in table
  3. PDO in PHP