\u9996\u5148\u9700\u8981\u5b89\u88c5\u8fd9\u51e0\u4e2a\u5305\uff1a
\nmutt\u3001uuencode\u3001sendmail<\/p>\n
\u811a\u672c\u5982\u4e0b\uff1a<\/p>\n
\r\n#!\/bin\/bash\r\n\r\n#need 2 var\r\nif (($# != 2)); then\r\n echo "need input [DBNamefile] [mode]"\r\n echo "mode -> 0, test DBNamefile read!"\r\n echo "mode -> 1, do DB bak!"\r\n exit;\r\nfi\r\n\r\nif (($2 < 0 && $2 > 1)); then\r\n echo "err mode!"\r\n exit\r\nfi\r\n\r\n#filter some lines:\r\n# 1. pure tab line\r\n# 2. pure \\r\\n\r\n# 3. pure space line\r\nDBNameFilePath=$1\r\nsed \/^[[:space:]]*$\/d $DBNameFilePath > $DBNameFilePath".tmp"\r\n\r\n#pre-info\r\nloop_count=0\r\nbak_DBName_target=1\r\necho "DBNameFilePath: "$DBNameFilePath" <<<>>> \u00a0DBNameFilePath_tmp: "$DBNameFilePath".tmp"\r\necho ============ output all db Name $(date +"%Y%m%d") ==================\r\nwhile read -r line\r\ndo\r\n #echo $line\r\n bak_DBName_target[loop_count]=$line\r\n ((loop_count++))\r\ndone < $DBNameFilePath".tmp"\r\n\r\ni=0\r\nfor ((;i<$loop_count && $loop_count>0;i++))\r\ndo\r\n echo ${bak_DBName_target[$i]}\r\ndone\r\necho "total - "$i\r\necho ============ end ==================\r\n\r\nif (($2 == 0)); then\r\n echo "test over"\r\n exit;\r\nfi\r\n\r\nif (($i<=0)); then\r\n echo "empty db name!"\r\n exit\r\nfi\r\n\r\n#do work\r\ni=0\r\nfor ((;i<$loop_count && $loop_count>0;i++))\r\ndo\r\n DBName_Tmp=${bak_DBName_target[$i]}\r\n DataBakName_tmp=Data_bak_${DBName_Tmp}_$(date +"%Y%m%d")\r\n\r\n #del db before 3 days\r\n rm -rf \/home\/backup\/Data_$(date -d -3day +"%Y%m%d").tar.gz\r\n\r\n #expory mysql db\r\n mysqldump -u root -ppassword $DBName_Tmp > \/tmp\/mysql_db_bak\/$DataBakName_tmp.sql\r\n\r\n #compact db file\r\n tar zcf \/tmp\/mysql_db_bak\/$DataBakName_tmp.tar.gz \/tmp\/mysql_db_bak\/$DataBakName_tmp.sql\r\n\r\n #del temporary sql\r\n rm -rf \/tmp\/mysql_db_bak\/$DataBakName_tmp.sql\r\n\r\n #Send mail\r\n mutt -s $DataBakName_tmp "email@163.com" -a \/tmp\/mysql_db_bak\/$DataBakName_tmp.tar.gz < mailbody.txt\r\ndone\r\n\r\n<\/pre>\n\u4e0a\u9762\u811a\u672c\u7684\u7528\u6cd5\u662f:<\/p>\n
\r\n.\/a.sh 1.txt 0\r\n<\/pre>\n1.txt\u662f\u4fdd\u5b58\u8981\u5907\u4efd\u6570\u636e\u5e93\u540d\u79f0\u7684\u6587\u4ef6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9996\u5148\u9700\u8981\u5b89\u88c5\u8fd9\u51e0\u4e2a\u5305\uff1a mutt\u3001uuencode\u3001sendmail \u811a\u672c\u5982\u4e0b\uff1a #!\/bin\/bash #need 2 var if (($# != 2)); then echo "need input [DBNamefile] [mode]" echo "mode …<\/p>\n