#!/bin/bash
Date=`date -d 'today' +%Y%m%d`
Date7=`date -d '7 days ago' +%Y%m%d`
backdir='/data/mysqldump'
mkdir -p $backdir
for i in `mysql --login-path=test -e "show databases" | grep -v test | grep -v information_schema | grep -v performance_schema | grep -v Database`
do
/usr/bin/mysqldump --login-path=test --single-transaction --master-data=2 --routines --flush-logs --flush-privileges --databases $i |gzip > $backdir/"$i"."$Date".sql.gz
done
find $backdir -name "*$Date7*.sql.gz" -exec rm -f {} \;