How to Export and Import PhpMyadmin database?

This article will tell you about export and insert databases.Sometimes you have to remove your databases from one place to another . Below are some steps explained, for export and import the database

How To Export Database?

STEP[1]. open Xampp controller and start Apache and Mysql


STEP[2]. open your browser and search there “localhost/dashboard”.click                             on”PhpMyadmin”


STEP[3]. Select the database which you want to export .after click on database                      press on “Export” tab


STEP[4]. press on “Go” for Export Database. after pressing on ‘GO’ you can see                   a SQL File in Download Section.That is your Database in SQL format.                  now you can use it for Importing database at another place.


How To Import Database?

STEP[1]. Start your XAMPP server then start browser and search                                           “localhost/dashboard”.Click on “PhpMyadmin” tab.


STEP[2]. Click on ‘Import’ button for Import a Sql file and import there your                       SQL file


STEP[3]. Select your SQL file and press “Go”


STEP[4]. after pressing “Go” you can see a new database in your you can see that i have imported data successfully.


My name is Kamalesh saini , working as e-mitra operator and web developer too. i am here to guide people who need help in learning php MySQL, HTML,CSS, and javascript.

Add comment

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.