How to download a backup copy of your MySQL database with PHPMyAdmin
In this tutorial we will show you how to download a backup copy of your MySQL database with the PHPMyAdmin interface.
Open PHPMyAdmin and click on your database-name in the left sidebar.
Click on Export
Select SQL as the format, check the Save as file checkbox and select a compression type. Click on Go. That's it. A backup file will be downloaded to your computer. You can upload that file to any database in order to recreate the structure and content of your backed-up database.