If we have a website that will be uploaded or created online, of course it includes the upload web files and database (if any). However, there are so many people who know what should be uploaded and how to upload the database it? Yes, it is actually quite easy. Enough with the export and import its database.

Export And Import MySQL Database Table

Simply follow the steps below: 

How to Export Database: 
1. Go to localhost / phpmyadmin
2. Click the database that will be exported.
3. Click the Export tab in the top menu.

If that will be exported is the entire contents of an existing table in the database, the Export option select only the Quick Method. And let alone SQL format.Click Go and most databases will instantly download.

How To Export And Import MySQL Database Table.

Exporting table from webmaster database

So what if you just want a few tables are in- export?
It is there if on one database, there table contents up to hundreds or even thousands.
For example, like this:

If that will be exported are only a few tables, the Export Method select the Custom option. And let alone SQL format.On the Table (s), select several tables that want to be exported.

Export Method

 After that, click Go and download SQL database.

How to Import Database: 
1. Go to localhost / phpmyadmin
2. Click the database that will be imported.
3. Click the import tab in the top menu.

Click Browse and select the sql that had been downloaded.Click Go. After that we had finished clicking -Import database :)

Importing SQL Database

Thanks. http://4g-bd.com