#!/bin/bashDATE=`date+%Y%m%d%H%M`#everyminuteDATABASE=xxxxxx#数据库名DB_USERNAME=xxxxxx#数据库用户名DB_PASSWORD=xxxxxx#数据库密码BACKUP_PATH=/home/csq/backup#备份路径DATE1=`date-d"$(date+%Y%m%d)-2weeks"+%Y-%m-%d\%H:%M:%S`echo"${DATE1}"echo"开始执行备份命令！"#mysqldump-u$DB_USERNAME-p$DB_PASSWORD$DATABASEt_task--where="create_time>='2019-10-0100:00:00'">${BACKUP_PATH}\/${DATABASE}_mysqldump-u$DB_USERNAME-p$DB_PASSWORD$DATABASEt_task--where="create_time<='${DATE1}'">${BACKUP_PATH}\/xxx_task_$(date+%Y%m%d%H%M).sqlecho"备份完成，开始执行删除命令！"echo"deletefromxxxxxx.xxxxxWHEREcreate_time<='${DATE1}'"|mysql-h127.0.0.1-uxxxxx-pxxxxxecho"删除完成，程序执行完毕！"
