For my existing websites and web development boxes that are online, I do let my web host perform automated backups. I see these compressed backup files and download them to my local machine for safe keeping and offline storage.
Either download from the file manager provided by the web host control panel, or using a secure connection (SSH) to the web server itself if I want to do some stuff on the command line.
I use a database control panel like phpMyAdmin to setup the backup routines, then I pull those backup files off the server to local storage.
A lot of this is pretty much the same on a Mac, since you only need a web browser to connect to your web hosting provider control panel. Please let me know if this helps. Thank you.