How to Backup a MySQL Database in cPanel Account – Host.co.in

Backing up a MySQL database is something you will require to do if you wish to export it. It also assures you have a backup copy of your database for emergency retrieval purposes.

Here are the easy steps you will require to begin to create a backup.

Step #1. Log into your cPanel account.

Step #2. Next, Go to the Databases section and click on phpMyAdmin.

Step #3. When phpMyAdmin opens, select the database you want to backup from the left side panel menu.

Step #4. Once you have created your choice, then click the Export tab at the head of the page.

Step #5. When the Export page opens, select the Quick Export choice, keep the format as SQL and press the Go button.

Step #6. Next, once you click the Go button, it will generate a database backup and download it to your local machine. Once the download is finished, you should save it to a secure folder.

Step #7. You can utilize this backup if you want to export your database to a different account or extra hosting solution.

Also Read: How to Create a MySQL Database in cPanel