需求：用linux自帶的郵件服務發(fā)送html格式的郵件,以下是最終的結(jié)果
1) 將要發(fā)送的內(nèi)容從MySQL取出來并生成.txt文件
backuplog.sh
#!/bin/bash
#mydumper多線程數(shù)據(jù)備份
export PATH=/usr/local/bin:/usr/local/mysql/bin:$PATH
#配置表及job信息存放位置
HOSTNAME="localhost"
PORT="3306"
USERNAME="root"
PASSword="123456"
today=`date "+%G%m%d"`
for ip in $(mysql -u $USERNAME -p$PASSWORD -h $HOSTNAME -P $PORT -e "select concat(ip,',',port,',',backupstatus) from mysqlcenter.backuplog where backupstatus='SUCCESS' and btype='end backup' and btime> DATE_FORMAT(NOW(),'%Y-%m-%d')union all select concat(ip,',',port,',',backupstatus) from mysqlcenter.backuplog where backupstatus='FAILED' and btype='end backup' and btime> DATE_FORMAT(NOW(),'%Y-%m-%d');
"|sed '1d')
do
echo $ip >> backuplog"$today".txt
done
最后保存并賦權(quán)chmod 777 sendmail.sh
2) 對上一步生成的.txt生成html格式的
sendmail.sh
#!/bin/bash
#FILE1_PATH="/root/wsktest/2.png"
FILE1_PATH=""
EMAIL_TITLE="測試"
today=`date "+%G%m%d"`
html_input(){
echo "<tr>
<td>$1</td>
<td>$2</td>
<td>$3</td>
</tr>" >>/data/email/mail.html
}
html_input_red(){
echo "<tr bgcolor="#FF0000">
<td>$1</td>
<td>$2</td>
<td>$3</td>
</tr>" >>/data/email/mail.html
}
set_info(){
i=1
echo "
<table border=1 border=1 cellspacing='0' cellpadding='0' >
<tr>
<th>table_name</th>
<th>source_count</th>
<th>target_count</th>
</tr>" > /data/email/mail.html
table_counts=$(awk -F "," '{print $1}' /data/email/backuplog"$today".txt) #表計數(shù)集合
for tablename in $table_counts
do
j=2
html_sour_count=$(awk -F "," 'NR==i { print $j}' i=$i j=$j /data/email/backuplog"$today".txt) #mysql中對應的計數(shù)
let "j++"
html_tar_count=$(awk -F "," 'NR==i { print $j}' i=$i j=$j /data/email/backuplog"$today".txt) #數(shù)倉中對應的計數(shù)
if [ "$html_sour_count" == "$html_tar_count" ];then
html_input $tablename $html_sour_count $html_tar_count #構(gòu)造每行表格信息
else
html_input_red $tablename $html_sour_count $html_tar_count #構(gòu)造每行表格信息
fi
let "i++"
echo $tablename $html_sour_count $html_tar_count $i $j
done
echo "</table>" >> /data/email/mail.html
}
set_info
EMAIL_Excel=$(cat /data/email/mail.html)
最后賦權(quán)chmod 777 backuplog.sh
3) 發(fā)送郵件
mail -s "$(echo -e "testnContent-Type: text/html;charset=gb2312")" "ji@163.com" <mail.html
4) 把這三步合并在一起成一步
email.sh
#!/bin/bash
bash /data/email/backuplog.sh
bash /data/email/sendmail.sh
cd /data/email
mail -s "$(echo -e "testnContent-Type: text/html;charset=gb2312")" "ji@163.com" <mail.html
最后賦權(quán)chmod 777 email.sh
