每天利用计划任务在凌晨1点自动执行，备份zabbix的数据库至本地的/backup/mysql_backup目录

#!/bin/shDUMP=/usr/bin/mysqldumpOUT_DIR=/backup/mysql_backupLINUX_USER=rootDB_NAME=zabbixDB_USER=rootDB_PASS=123456cd $OUT_DIRDATE=`date +%Y%m%d`OUT_SQL="$DATE.sql"TAR_SQL="data_bak_$DATE.tar.gz"$DUMP -u $DB_USER -p$DB_PASS $DB_NAME --default-character-set=utf8 --opt -Q -R --skip-lock-tables --master-data=1 > $OUT_SQLtar -czf $TAR_SQL ./$OUT_SQLrm $OUT_SQLfind /backup/mysql_backup/ -name 'data_bak*' -ctime +10 -exec rm -f {} \;