I am looking for suggestions on how to do a comprehensive nightly offsite backup of everything. I am mildly tech savvy, so I can muddle through most suggestions. I am thinking it might look something like this: * cron to backup all mysql data to a specific directory * nightly automated ftp to pull down entire site, including above directory Am I missing something? How might I go about setting up a cron that would do that? Are there better ideas, or off-the-shelf solutions for this? I am very appreciative for all suggestions.
I managed to put together a backup solution that does what you described, though a programmer could do a better job than what I put together. I use a couple simple shell scripts, that run on a cron, to dump the mysql databases into a directory -- saving the last 3 backups. Another cron runs rsync and does an incremental backup of the entire site (including the directory with the databases) to an off-site location. I use BQbackup.com for this. Then I duplicated the process (using cron) to run daily, weekly, and monthly. Feel free to contact me for details.