#!/bin/bash
#mysql backup admin
cd /root/backup
dateDir=`date +"%y-%m-%d"`
dateDir2=`date -d '-2 day' +%y-%m-%d`
mkdir -p $dateDIR/data
for i in `/usr/bin/mysql -uroot -pabc123? -e "show databases"|grep -v "Database"|grep -v "information_schema"`
do
        /usr/bin/mysqldump -uroot -pabc123? $i|gzip >/root/backup/${i}_${dateDir}.gz
        rm -rf /root/backup/${i}_${dateDir2}.gz
        done