MediaTemple (dv) backup using Dropbox
On my server I have the follow file to backup my databases locally:
/var/www/vhosts/backup/backupdatabases.sh
#!/bin/sh
# The destination directory to backup the files to
destdir=/var/www/vhosts/_backup
# The MySQL database hostname
dbhost=localhost
# The MySQL database username - requires read access to databases
dbuser={database_username}
# The MySQL database password
dbpassword={database_password}
echo `date` ": Beginning backup process..." > $destdir/backup.log
# remove old backups
rm $destdir/*.tar.gz
# backup databases
for dbname in `echo 'show databases;' | /usr/bin/mysql -h $dbhost -u$dbuser -p$dbpassword`
do
if [ $dbname != "Database" ];
then
echo `date` ": Backing up database $dbname..." >> $destdir/backup.log
/usr/bin/mysqldump --opt -h $dbhost -u$dbuser -p$dbpassword $dbname > $destdir/$dbname.sql
tar -czf $destdir/$dbname.sql.tar.gz $destdir/$dbname.sql
rm $destdir/$dbname.sql
fi
done
mail -s "Backup Complete" {email_address} < $destdir/backup.log
Here is what the cron job looks like in Plesk.
The rest of my backup I run from my local development machine. On my machine I'm using a paid version of <a href="http://db.tt/zGs2ic0">Dropbox</a> with the Packrat (unlimited undo history). The Packrat feature is what allows me to restore back in time to a particular date. Here is the file I'm using:
~/Dropbox/AnchorDevDevelopment/backup/backup-{servername}.command
#!/bin/bash
rsync --progress --force --delete --exclude 'fs' -azve ssh {username}@{hostname}:/var/www/vhosts ~/Dropbox/Backup/AnchorDev/{servername}/
Here is what my crontab looks like in CronniX on my local machine
Written by Austin Ginder
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Backup
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#