linux上mysql数据备份并自动通过附件发送到指定邮箱

# !/bin/bash

# -----------------------------------------------------------------------------

# Start Script for the backup the database

# -----------------------------------------------------------------------------

export JAVA_HOME=/home/lsf/Programs/java/jre1.6.0_18

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

#shutdown the tomcat server 

/home/lsf/Programs/tomcat5/bin/shutdown.sh

sleep 20

#Get the system date

day=`date '+%Y-%m-%d'`

filename="${day}.sql"

mysqldump -uroot -pPassword db >/home/lsf/Deploy/data/$filename

echo $filename

#start the tomcat server 

/home/lsf/Programs/tomcat5/bin/startup.sh

#add by lsf at 2010-03-27

#auto send database backup to following addresses through  mutt & msmtp 

#gzip file  压缩文件

gzip -f /home/lsf/Deploy/data/$filename

#send the mail and set the database backup file as attachment 以附件方式发送数据库辈分 mutt & msmtp

mutt -s "kp database backup ${day}"  -a /home/lsf/Deploy/data/${filename}.gz  i03630215@126.com < /home/lsf/AutoMail/mailcontent

在/etc/Multtrc 配置文件中 更改set realname=用于发送邮件的邮箱地址

配置Mutt  /usr/etc/msmtprc

defaults

account  邮箱账户

host smtp服务器

from 邮箱账户

auth login

user 邮箱账户

password 密码

account default:默认账户

#日志文件

logfile /home/lsf/AutoMail/maillog