Backup offsite using sftp
Anybody implement a script that is backing up the database offsite using sftp? How did you do it?
If you're on Mac ?
Schedule a FMS Backup with number to keep set to one, at a precise time (like 8 PM, when everyone is off the DB).
at 8:15 (make sure you left enough time), launch an applescript.app script that does a do shell, that zips the backup folder and encrypts it, and then push it wherever you want using ftp/sftp, rsync whatever you can script in command line.
Me, I jusst zip it and put in in a cloud folder (like dropbox), but before it did ftp it
Retrieving data ...