数据库备份-备份到七牛

chizhong7847

于 2018-08-20 12:34:00 发布

阅读量147

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/jeebey/blog/1930703

版权

#!/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

转载于:https://my.oschina.net/jeebey/blog/1930703