I'm use to using all these different software packages available to other CMS sites like Wordpress, Joomla, Drupal, etc.. that would perform routine backups of your site and make it very easy to restore. In fact cPanel has backup and restore built in for Wordpress sites but that's where it stops. Apparently we are all suppose to use the very slow Wordpress solution. NOT!
Briefly here is how you can create the routine to backup your website regardless
1st concentrate on the Database backups since many times you could reinstall the software but much of the content you can find in the database.
BACKUP DATABASE in cPANEL with CRON JOB
OPTION 1
cpanel
cronjobs
/usr/bin/mysqldump -u dbusername -p 'dbpassword' dbname > /path/backup.sql
OPTION 2
file manager
+ file
.my.cnf
edit .my.cnf
[client]
user = dbusername
password = "dbpassword"
host = localhost
SAVE CHANGES
cronjobs
mysqldump dbname > /path/backup.sql >/dev/null 2>&1
Now let's concentrate how to backup the files for your website since many of us have files/attachments and we want them to retur
