How to Back Up a MySQL Database in cPanel

Backing up a MySQL database is something you will need to do if you wish to export it. It also ensures you have a backup copy of your database for disaster recovery purposes. Here are the steps you will need to undertake in order to create a backup.

Log into your cPanel account.
Scroll down to the Databases section and click on phpMyAdmin.
This image has an empty alt attribute; its file name is Screenshot-236-1.png
3. When phpMyAdmin opens, choose the database you wish to backup from the list in the left side panel.

This image has an empty alt attribute; its file name is Screenshot-237-1.png
4. Once you have made your selection, click the Export tab at the top of the page.

This image has an empty alt attribute; its file name is Screenshot-238-1.png
5. When the Export page opens, choose the Quick Export option, keep the format as SQL and then press on the Go button.

This image has an empty alt attribute; its file name is Screenshot-239.png
6. Once you click Go, your database backup will be created. It will then be exported as a download to your local machine. Once the download is complete you should 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.

 

Creed Hosting  can help you  to take backups.Please write at info@creedhosting.com

Related Articles