Linux based Website Backup
Can anyone recommend any good Linux based website backup solutions? I have a hosted server where I host a course website- the server runs Ubuntu and the hosting provider also provides dedicated FTP backup space.
On this basis it'd be great if there was a solution that I could run on the server that incrementally backs up the website files and SQL databases on a schedule to this FTP space. Ideally it'd manage versions, keeping changes and deleting versions older than x days.
I also have a Open Solaris server hanging off a Be line in the apartment and to be really paranoid it'd be great to back the website up to a folder here as well. This could either be the same solution (although I guess maybe I'd have to invest in another SSL cert for the incoming connection from the website server) or something initiated from the Solaris server.
Of course there is nothing stopping me simply using Robocopy (someone told me there is an equivalent for Linux) to replicate the FTP storage space with the original backup. In that case it'd be good if there was some kind of monitoring I could put in place to let me know if files haven't been written in x days (or a daily e-mail to say backup has run) so I can be confident backup will be there should the worst happen.
At present I use Site Vault which is Windows Based and has limitations for power user use- it's only possible to roll back an entire backup (think Windows Restore Points) rather than reverse one specific change. Since I'm going to lose Windows Server anyway (won't be renewing TechNet this year) this time seems ripe for a change.