导入

#!/bin/bash
PATH=/bin:/sbin:/usr/sbin:/usr/local/sbin:/usr/local/bin:/usr/bin
export PATH
DBBK_USER=xxxx #备份数据库用户名
DBBK_PWD="xxxx" #备份数据库用户密码
PATH=/tmp/backup/*.sql
DBBK_COM_PREFIX="mysql -u${DBBK_USER} -p${DBBK_PWD}" #数据库备份命令前缀
cd /tmp/backup
for DB_NAME in $(ls ${PATH})
do
    ${DBBK_COM_PREFIX} -e "create database ${DB_NAME}"
    ${DBBK_COM_PREFIX} ${DB_NAME} < ${DB_NAME}.sql
done