计划任务
crontab -e
输入:
00 00 * * * /root/mysqlbackup.sh
即为每天00:00自动运行备份脚本。
#!/bin/sh
DBUser=root
DBPass=123456
BackupPath=/bak/mysql
time="$(date +"%d-%m-%Y")"
for db in discuz ucenter
do
mysqldump -u$DBUser -p$DBPass $db> $BackupPath/$db.$time.sql
sleep3600s
wait
#压缩备份文件
tar zcf $BackupPath/$db.$time.sql.tar.gz $BackupPath/$db.$time.sql
#发送到指定邮箱
echo "主题:数据库备份" | mutt -a $BackupPath/$db.$time.sql.tar.gz -s "内容:数据库备份" hanjingzheng@163.com
#mutt是附件
#基础脚本自动导出mysql备份,并上传到指定ftp
sleep 3600s
wait
#ftp设置
Host=FTP_IP
Username=FTP_user
Passwd=FTP_passwd
#上传到ftp
echo "open $Host
user $Username $Passwd
bin
cd /hzg/
prompt off
mput $BackupPath/$db.$time.sql.tar.gz $db.$time.sql.tar.gz
printf "\n"
close
bye"|ftp -i -n
sleep 3600s
wait
done