How to Back Up a MySQL Database in cPanel

Backing up a MySQL database are a something you may required to do if you would like to export it. It additionally ensures you have a backup copy of your database for disaster recovery functions. Here are the steps you may required to undertake so as to make a backup.

1. Log into your cPanel account using username and password.
2. Down from the Databases section and click on phpMyAdmin.

backup-1

3. When phpMyAdmin opens, select the database you want to backup from the list in the left side panel.

backup-2
4. Once you have made your selection, click the Export tab which is located at the top of the page.

backup-3
5. Once the Export page opens, choose the Quick Export option, keep the format as SQL and then press on the Go button.

backup-4

6. After you click Go, your database backup will gets created. It will then be exported as a download to your local machine. When the download is complete you must save it to a secure folder.
7. You can use this backup if you wish to export your database to another account or to another hosting solution.