I have had a look in the tutorials section above but the threads there seem to deal with BQbackup or Amazon S3 and besides that don't mention database dumps and backup rotation. If I have missed one with information in there applicable to my query then I apologise in advance and hope you'll point me in the right direction 
On to my issue...
I would like to set up a daily automated backup routine that will do a full database dump of some databases belonging to one of the accounts on my VPS and also the contents from one folder belonging to the same account. These should then be transferred from the VPS here to a second VPS that I have just for backups. The backups from the one folder can be incremental but the DB’s should be a full dump from each day so that I always have more than one DB backup available in case of issues.
Once the DB backups cover the last 7 days I would then like the newest backup to overwrite the oldest on the backup server, always leaving me with just 7 days worth of DB backups and the one, constant up to date copy of the folder. All of this should be fully automated requiring no human intervention.
I submitted a ticket enquiring if this was possible but the response was mainly to give me instructions on setting up automated backups for one account in WHM. Obviously that doesn’t meet my requirements to just backup selected databases and one folder, plus it takes no account of rotating the backups on the remote server.
So my question is can the above be done automatically with the software already installed on my VPS and if so, how would I go about getting this set up and running?
Any help is greatly welcomed.
On to my issue...
I would like to set up a daily automated backup routine that will do a full database dump of some databases belonging to one of the accounts on my VPS and also the contents from one folder belonging to the same account. These should then be transferred from the VPS here to a second VPS that I have just for backups. The backups from the one folder can be incremental but the DB’s should be a full dump from each day so that I always have more than one DB backup available in case of issues.
Once the DB backups cover the last 7 days I would then like the newest backup to overwrite the oldest on the backup server, always leaving me with just 7 days worth of DB backups and the one, constant up to date copy of the folder. All of this should be fully automated requiring no human intervention.
I submitted a ticket enquiring if this was possible but the response was mainly to give me instructions on setting up automated backups for one account in WHM. Obviously that doesn’t meet my requirements to just backup selected databases and one folder, plus it takes no account of rotating the backups on the remote server.
So my question is can the above be done automatically with the software already installed on my VPS and if so, how would I go about getting this set up and running?
Any help is greatly welcomed.