【Xampp】Import Database or table into phpMyAdmin

Xampp - Import Database or table into phpMyAdmin

How to - Import Database or table into phpMyAdmin

In this post will shows you steps on how to import database or single table into phpMyAdmin by using SQL file.

Table of - Content

Import Database

No.	Title
1	Open up your phpMyAdmin Page
2	Go to Import tab
3	Import database

Import Table

No.	Title
1	Open Up Your Database
2	Import Table

Import Database

1 - Open up your phpMyAdmin Page.

First open up your phpMyAdmin page for my case I am using Xampp, after you have open your phpMyAdmin page go to left pane, click the database that you wan to import into (testdb). If you don’t have a database Create one first.

<- Screenshot

2 - Go to Import tab.

After you have click on the database(testdb) that you want to backup, next go to the top click on the export button.

<- Screenshot

3 - Import Database.

After you have click on the export button scroll to the bottom if needed you will see a Format section :

Select the format you wan to export(I am exporting as SQL)
After select click Go button.

After you have click go, it will start download (depend on your browser download behavior).

<- Screenshot

Import Table

1 - Open Up Your Database.

First, open up your database that you want to import table to :

Click on your database.
Go to Import tab.
Click Choose File, and select the table SQL file to import.

<- Screenshot

1 - Import Table.

After, choosing your SQL file, scroll to the bottom if needed, and click Go button, after click go your table will be imported to the database that your have selected.