How to backup your website files and website's database using cPanel
1. Login to cPanel
--- Database Backups ---
2. Under Databases click phpMyAdmin (a new tab opens)
3. Click on your database name on the left (e.g. '_databasename')
4. Click on the Export tab
------ Keep all default values except the following:
5. Under Export Method select 'Custom - display all possible options'
6. Ensure that all tables are selected
7. Under Output: Compression: choose 'gzipped'
8. Under 'Format-specific option' checkmark 'Enclose export in a transaction'
9. Under 'Format-specific option' checkmark 'Disable foreign key checks'
10. Under 'Object creation options' checkmark 'Add DROP TABLE...'
11. Click Go at the bottom of the page
12. You will then be prompted for a location to save your database file. Choose a location on your computer and click save.
13. When finished you can close the tab for phpMyAdmin
--- Website Files Backup ---
14. Under Files click on File Manager - A new tab will open
15. Navigate to your to location of your website files (e.g. 'public_html')
16. Select the files you want to backup
17. Click the Compress button at the top
18. Choose the 'Zip Archive' option in the popup window
19. Where it reads 'app.zip' rename to something like accountname_subfolder_2014-12-30_a.files.zip
20. Click Compress Files button
21. When it's done click Close
22. Right-click on the zipped file that you just created and choose Download
23. Choose a location on your computer to save your website files
