#!/bin/bash
# backup-mysql.sh - Script to securely, remotely
# backup mysql databases.
# last modified 6-12-07
# by Pig Monkey (pm@pig-monkey.com)
################################################

cd /home/user/backup/
mkdir crypt
suffix=$(date +%F)
mysqldump --opt -uuser1 -ppass1 -h hostname1 dbname1 > dbname1.$suffix.mysql
/usr/bin/md5sum dbname1.$suffix.mysql > dbname1.$suffix.mysql.md5
mysqldump --opt -uuser2 -ppass2 -h hostname2 dbname2 > dbname2.$suffix.mysql
/usr/bin/md5sum dbname2.$suffix.mysql > dbname2.$suffix.mysql.md5
tar -cvzf crypt/mysql_backup.$suffix.tar.gz *$suffix.mysql*
/home/user/bin/ncrypt -e -k key -i crypt/mysql_backup.$suffix.tar.gz -o crypt/mysql_backup.$suffix.tar.gz.crypt
/usr/bin/mutt -s "MySQL Backup" -a crypt/mysql_backup.$suffix.tar.gz.crypt user@someremotelocation.com < /home/user/bin/backup-mysql-message
rm -r crypt/