How to download a backup copy of your MySQL database with PHPMyAdmin

07.28.2013 by Ilia Raiskin
MySQL PHPMyAdmin

In this tutorial we will show you how to download a backup copy of your MySQL database with the PHPMyAdmin interface.

Step 1

Open PHPMyAdmin and click on your database-name in the left sidebar.

Screenshot of PHPMyAdmin start-page

Step 2

Click on Export

Screenshot of PHPMyAdmin database page

Step 3

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.

Screenshot of PHPMyAdmin export page

About the author

Ilia Raiskin

Ilia Raiskin is a web designer, web developer, blogger and founder of Toolinfy.com.






Comment