The script below is triggered every day from my Mac. I use Hazel to move the tar.gz to an external hard disk once it's finished. This happens every day without me noticing. You can exclude folders if you want to. You probably want to exclude giant cache folders.
You should have a similar script.
Thanks for this, my host doesn't play nicely with WordPress backup plugins, but this script seems like its a great workaround.