mysql定时数据备份
#!/bin/sh
currdir=`pwd` #脚本的启动路径
backupdir=$currdir/dump_his #导出到那个目录
currdate=`date +%Y%m%d` #当前时间
echo "`date +%c` BACKUP BEGIN..." >> backup.log;
mysqldump --default-character-set=UTF8 --skip-lock-tables --single-transaction --hex-blob -h主机地址 -P端口 -u用户 -p密码 --databases 数据库名 > $backupdir/$currdate.dump;
cd $backupdir
tar -czf $currdate.tar.gz $currdate.dump;
rm -rf $currdate.dump;
cd $currdir
#报错15天的数据
find $backupdir -name "*.tar.gz" -type f -mtime +15 -exec rm -rf {} \;
echo "`date +%c` BACKUP SUCESS!" >> backup.log;