gistfile1.txt

# Linux 自动备份 MySQL与网站并发邮件到自已邮箱 1
# 1.将刚才到处的MySQL文件压缩，以节省邮箱空间
tar zcf $BACKUP_PATH/pasite_db_$DATE_NAME.tar.gz $DATE_NAME/pasite.sql
tar zcf $BACKUP_PATH/personlab_db_$DATE_NAME.tar.gz $DATE_NAME/personlab.sql
# 2.打包压缩网站
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/

# Linux 自动备份 MySQL与网站并发邮件到自已邮箱 2
# 发送邮件
echo "pasite.org db backup" | mutt -a $BACKUP_PATH/pasite_db_$DATE_NAME.tar.gz -s "pasite.org db backup" -c huacnlee@gmail.com
echo "huacnlee.com db backup" | mutt -a $BACKUP_PATH/personlab_db_$DATE_NAME.tar.gz -s "huacnlee.com db backup"  -c huacnlee@gmail.com
echo "pasite.org source backup" | mutt -a $BACKUP_PATH/pasite_src_$DATE_NAME.tar.gz -s "pasite.org source backup" -c huacnlee@gmail.com
echo "huacnlee.com source backup" | mutt -a $BACKUP_PATH/personlab_src_$DATE_NAME.tar.gz -s "huacnlee.com source backup" -c huacnlee@gmail.com

# -uroot(root是用户名 -u与root之间没空格) -p123123 (123123是密码 -p与123123之间没空格)
mysqldump -uroot -p123123 --databases pasite > $BACKUP_PATH/pasite.sql