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.
3. When phpMyAdmin opens, select the database you want to backup from the list in the left side panel.
4. Once you have made your selection, click the Export tab which is located at the top of the page.
5. Once the Export page opens, choose the Quick Export option, keep the format as SQL and then press on the Go button.
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.