数据库远程备份

#!/bin/shDATABASE_PORT=(3306 \3307 \)for port in `echo ${DATABASE_PORT[@]}`do        mkdir -p /data0/mysqlbak/${port}/`date '+%Y-%m-%d'`                for database in `/usr/local/webserver/mysql/bin/mysql -u xoyo -h 192.168.8.38 -pxoyo.com -P 3306 -e "show databases\G;" | grep "Database" | grep -v information_schema | grep -v mysql | grep -v test | awk -F: '{print $2}'`        do          cd /data0/mysqlbak/${port}/`date '+%Y-%m-%d'`/                    /usr/local/webserver/mysql/bin/mysqldump -u xoyo -h 192.168.8.38 -pxoyo.com --extended-insert=false -P ${port} $database > ${database}.sql                    tar cvzf ${database}.sql.tar.gz ${database}.sql                    rm -f ${database}.sql                done                if [ -d /mysqldump/${port}/`date -d '-7 day' +%Y-%m-%d` ]                then                   rm -rf /mysqldump/${port}/`date -d '-7 day' +%Y-%m-%d`                fidone