Import and Export of Database

In this tutorial you will learn how to export and import database in PhpMyAdmin.

Steps to Export Database:

1.   Run Wamp server. Go to PhpMyAdmin.
2. On left side you see list of databases. Database that you want to export click on it.
3. On top you see different options click on EXPORT.
4. Check Save as file and zipped option and click on Go.
5. Give path wher you want to save sql zipped folder.
6. Database is exported successful.

Steps to Import Database:
For importing database you have to create a new database with a same name that you are going to import.

1. Unzip your sql zipped folder.
2. Create a new database with same name that you want to import.
3. After creating new database. on top you see import option click on it.
4. Browse Sql text file and click on Go.
5. Your database is imported successfully.

Posted in: amna zafar, import and export of database, joomla help, phpmyadmin