mysql自动备份、压缩、并通过ftp上传到指定服务器

mysql 
/etc/my.inf 添加
[mysqldump]
default-character-set=utf8
host=localhost
user=mysqluser
password=mysqlpwd

定时任务shell
crontab -e
*/1 * * * * /usr/local/dbback/dbback.sh
自动备份、压缩、并通过ftp上传到指定服务器
#!/bin/bash
#backtime
backtime=$(date +"%Y%m%d%H%M%S")
#echo ${backtime}
#log path
logpath=/usr/local/dbback
#data path
datapath=/usr/local/dbback
echo "backtime:${backtime},back database:scm begin" >> ${logpath}/back.log
#data back shell
/usr/local/mysql/bin/mysqldump --defaults-extra-file=/etc/my.cnf -R scm --hex-blob>${datapath}/${backtime}.sql
#/usr/local/mysql/bin/mysqldump -R -ndt scmback -uroot -ppwd>${datapath}/proceduce_${backtime}.sql
#zip
cd ${datapath}
tar jcf ${backtime}.tar.bz2 ${backtime}.sql > /dev/null
rm -f ${datapath}/${backtime}.sql
echo "back success!!" >> ${logpath}/back.log
ftp -v -n 192.168.3.6<<EOF
user ftpuser ftppwd
binary
cd dbback
put ${backtime}.tar.bz2
bye
#here document
EOF
echo "commit to ftp successfully"