#!/bin/bash set -e #测试 HOSTNAME='127.0.0.1' PORT='3306' USERNAME='root' PASSWORD='root' #罗列数据库名 SELECT_DB_SQL="select SCHEMA_NAME from SCHEMATA where SCHEMA_NAME IN ('test')" for db in `mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} information_schema -e"${SELECT_DB_SQL}" |grep -v SCHEMA_NAME` do mysqldump -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${db} | gzip > ${db}-`date "+%Y%m%d%H%M"`.gz | qshell fput data-backup ${db}-`date "+%Y%m%d%H%M"`.gz ${db}-`date "+%Y%m%d%H%M"`.gz done