autobackup.sh

#!/bin/sh
# Linux 自动备份 MySQL与网站并发邮件到自已邮箱
# 定义临时目录
BACKUP_PATH=/tmp/autobackups
# 定义日期字符串
DATE_NAME=`date +%y%m%d`
# 创建临时目录
mkdir $BACKUP_PATH

# 打包文件
# 1.完整备份 MySQL -uroot(root是用户名 -u与root之间没空格) -p123123 (123123是密码 -p与123123之间没空格)
mysqldump -uroot -p123123 --databases pasite > $BACKUP_PATH/pasite.sql
mysqldump -uroot -p123123 --databases personlab_production > $BACKUP_PATH/personlab.sql
# 2.将刚才到处的MySQL文件压缩，以节省邮箱空间
tar zcf $BACKUP_PATH/pasite_db_$DATE_NAME.tar.gz $backup_path/pasite.sql
tar zcf $BACKUP_PATH/personlab_db_$DATE_NAME.tar.gz $backup_path/personlab.sql
# 3.打包压缩网站
tar zcf $BACKUP_PATH/pasite_src_$DATE_NAME.tar.gz ~home/huacnlee/wwwroot/pasite/
tar zcf $BACKUP_PATH/personlab_src_$DATE_NAME.tar.gz ~home/huacnlee/wwwroot/personlab/

# 发送邮件
echo "pasite.org db backup" | mutt -a $BACKUP_PATH/pasite_db_$DATE_NAME.tar.gz -s "pasite.org db backup" -c [email protected]
echo "huacnlee.com db backup" | mutt -a $BACKUP_PATH/personlab_db_$DATE_NAME.tar.gz -s "huacnlee.com db backup" -c [email protected]
echo "pasite.org source backup" | mutt -a $BACKUP_PATH/pasite_src_$DATE_NAME.tar.gz -s "pasite.org source backup" -c [email protected]
echo "huacnlee.com source backup" | mutt -a $BACKUP_PATH/personlab_src_$DATE_NAME.tar.gz -s "huacnlee.com source backup" -c [email protected]

# 删除临时文件
rm -R $BACKUP_PATH