To download a backup of a MySQL database:
- Login to cPanel by going to www.yourdomain.com.au/cpanel
- Under Files, click Backups
- Under "Partial Backups > Download a MySQL Database Backup", click the database that you wish to download, and save the file to your computer
Restore a MySQL database in cPanel from a backup
If you have a backup of your MySQL database, such as one generated by the method above, and you need to restore it so that it overwrites the database currently used by your website, you can do this as follows:
- Login to cPanel by going to www.yourdomain.com.au/cpanel
- Under Databases, click phpMyAdmin
- On the left, click the name of the database you wish to overwrite. This should display a list of tables on the right.
- At the bottom, click the "Check All" link to select all tables. From the select box to its right, choose "Drop". Important: This will destroy all data in the database you have chosen. Be certain that you have selected the correct database and that you have a working backup that you are about to restore from.
- Up the top of the page, click the Import tab.
- Under "File to import", click the upload button, and browse to the MySQL database backup file on your computer. It may have a .sql, .gz or .zip extension.
- Click the "Go" button.
