You can use the backup utility in your cPanel account or you can manually backup using phpMyAdmin.
To manually backup using phpMyAdmin follow these steps:
- To manage your MySQL database, you'll first need to log into your cPanel.
- After you are logged into the cPanel, click on phpMyAdmin located under Database Management Tools
- Once the page has fully loaded you will see a list of of databases to your left click the database you want to export. (One at time allowed)
- Then on the menu, click Export:
This interface will generate a backup file that can be used to recreate your database or table (it's actually just a file containing standard SQL statements).
To save the backup, you will need to check the box marked Save as file, so that phpMyAdmin will prompt you to download the resulting backup file. You can also change the name of the backup file and the compression--though the defaults are both fine if you would rather not change anything. If you do choose to use compression this will allow you to have a smaller backup file on your desktop if you are planning to keep it as a personal archive. The recommended setting is "gzipped":
Finish by pressing the Go button; this may take a few moments to complete. You will then be prompted to save the file to your desktop.
