From EZP Knowledge Base

When you run a database powered website, it is very important to keep a current backup of your databases! When you run a full cPanel backup, you do get a backup of your mysql databases with it, however there are times when there is no need to backup the whole site and just a database backup will do. To backup only your mysql databases follow these steps:

• Login to cPanel!
• Click Backups (under the "Files" heading)

• Under Download a MySQL Database Backup click the name of the database for which you wish you would like to back up.

• Click save as or select a destination for where you would like the back up to locally be saved to. You can never have too many backups!

If you make a mistake with a database, you can always restore the database very easily. To restore a database, please do the following:

• Click Backups (under the "Files" heading)
• Click the Browse button next to the option which says “Restore a MySQL Database”

• Select the SQL file for which you would like restored.
• Click the open button and click the upload button.

Congratulations, you've just restored your database! If you have any problems, you can always email support.