Skip to content

Instantly share code, notes, and snippets.

@huacnlee

huacnlee/gist:505637

Created August 3, 2010 01:09
Show Gist options
  • Save huacnlee/505637 to your computer and use it in GitHub Desktop.
Save huacnlee/505637 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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 [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]
# -uroot(root是用户名 -u与root之间没空格) -p123123 (123123是密码 -p与123123之间没空格)
mysqldump -uroot -p123123 --databases pasite > $BACKUP_PATH/pasite.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment