#!/bin/bash pid=/data/mysql/bin/ user=root password=123456 back=/data/backup ip=127.0.0.1
[ ! -d $back ] && mkdir -p $back dblist=`$pid/mysql -u$user -p$password -h$ip -e "show databases;"|sed 1d|grep -v _schema|grep -v test` for name in $dblist do $pid/mysqldump -u$user -p$password -h$ip -B $name|gzip >/$back/${name}_$(date +%F)_bak.sql.gz done find $back -name "*.sql.gz" -mtime +15|xargs rm -fr
