How to Backup your MySQL Database Using phpMyAdmin

 

 

 

2) Click on the database you would like to backup from the left sidebar.  In the following example we plan on backing up the database named "mysql".  Here you should select your specific database name and not "mysql".

 

 

3) Click on the Export tab.

 

 

4) Choose the Quick Export Method, leave the Format as SQL and then click on the Go button.

 

 

5) The export file of your database will be downloaded to your local computer and will be saved in your browser's default downloads folder.