Exporting and Importing data in Xampp

---

Exporting and Importing data in Xampp 


xampp is used to build up local server in our PC.where we run these php scripts.After the development of an application is over we have to transfer the pages and data in database in to a remote server.File transfer is very easy but data base transfer?.. It also very easy due to exporting and importing facilities in xampp.

Exporting Data from Xampp

We will look at the  table we created as namelist in xampp interface.you have to go xampp interface by typing URL:-http://localhost/phpmyadmin/ then you would see the following interface.

Then select my_database you would see the tables in my_database

Click on the table namelist you would see bellow table

Then press the export tab in xampp and then press Goyou would see bellow picture.

 Then right click on the above page and select all,copy the consent and paste into a note pad name it as .txt file in your own name in my case i have named it as dump.txt.

Then create database in any name.I have created it as blog

Then press import tab then bellow window appears.

Then browse the dump.txt you created and press Go table name list will be created as follows.

---