# 对比 [root@localhost ~]# bypy compare v6/bypy ./bypy ==== Same files === F - MANIFEST.in ... omit ... F - bypy/monkey.py F - README.md ==== Different files === ==== Local only ==== ==== Remote only ==== F - release.sh
[root@localhost ~]# vim mysql_back.sh #!/bin/bash # # backup mysqldump file to baidu yunPan # filepath: /usr/local/bin/mysql_back.sh # Author: samzong #
function upload_file(){ TIME=`date "+%Y%m%d%H%M%S"` folder="/mysqlbak" filename="db_$TIME.sql" filePath=$folder/$filename
if [ ! -f $filePath ]; then echo "[ERROR]["`date +%Y-%m-%d' '%H:%M:%S`"] $folder/$filename not found." else echo "[INFO]["`date +%Y-%m-%d' '%H:%M:%S`"] $folder/$filename has been found. Start uploading ......" bypy upload "$filePath" "v6/mysql_backup/$filename" echo "[INFO]["`date +%Y-%m-%d' '%H:%M:%S`"] Uploading end." fi }
#set TIME variable TIME=`date "+%Y%m%d%H%M%S"`
# backup db ghost to /mysqlbak/ mysqldump --single-transaction -h localhost -u ghost_backuser -pbackupPass ghost > /mysqlbak/db_$TIME.sql
# tar sql file tar czvf /mysqlbak/ghost_$TIME.sql.tgz /mysqlbak/ghost_$TIME.sql --remove-files
# upload sql file to baidu yunPan. upload_file;
# send mial to admin'mial if [ $? -eq 0 ]; then echo "ghost SQL dump is successfully. At time: `date` " | mail -s ghost-dump-successfully samzong.lu@gmail.com else echo " Error Error ghost SQL dump is Error. At time: `date` " | mail -s ghost-dump-error samzong.lu@gmail.com fi
添加计划任务
1 2
~ crontab -e 00 00 * * * sh /usr/local/bin/mysql_back.sh