How to backup your MySQL database?

MySQL Export

You can easily create a dump file(export/backup) of a database used by your account. In order to do so you should access the phpMyAdmin tool available in your cPanel:




The phpMyAdmin tool will be loaded shortly.


You can select the database that you would like to backup from the drop-down menu called Database (located in the upper left corner of the page).





A new page will be loaded in phpMyAdmin showing the selected database. In order to proceed with the backup click on theExport tab:



The options that you should select apart from the default ones are Save as file (which will save the file locally to your computer in an .sql format) and Add DROP TABLE (which will add the drop table functionality if the table already exists in the database backup) as shown below:



Click on the Go button to start the export/backup procedure for your database:



A download window will pop up prompting for the exact place where you would like to save the file on your local computer. It is possible that the download starts automatically. This depends on your browser's settings.