We have already discussed about how to take a database backup and restore in MySQL using mysqldump command, do you feel it's very difficult can get backup using the PHPMyAdmin tool.

For example, I will take a backup  database name is exportmysql and restore into importmysql database.

Open the PHPMyAdmin : http://localhost/phpmyadmin/ (If you have installed in your local system)

Export / Backup Database PHP MyAdmin :

Select that database and click  on exportmysql database, listed on left side column.



Then, the page will shows like below image, Click on “ Export ”



There are two ways to export database, one is Quick and another one is Custom (Select particular tables and other options),  Click on  “Go”



Choose Custom option and select specific tables as you like,



Save the backup with .sql format.

Import  / Restore Database:

Import is very simple process before we going to do that, create a database (importmysql),

Choose the importmysql database on left side column



Click on Import Icon like below images,


Click on  Browser to get database backup from your system ,

Then, Click on  Go  button


Browser your computer please be patient, the file is being uploaded.
After done it showing below comments,
Import has been successfully finished, 29 queries executed. (exportmysql.sql)



Now, if you click on database name listing out tables.