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.
- When phpMyAdmin opens, choose the database you wish to backup from the list in the left side panel.
- Once you have made your selection, click the Export tab at the top of the page.
- When the Export page opens, choose the Quick Export option, keep the format as SQL and then press on the Go button.
- 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.
- You can use this backup if you wish to export your database to another account or to another hosting solution.
In such a manner, you can back up a MySQL database in cPanel. If you encounter any issues, feel free to connect with our technical team. They are available 24X7.