博客

#!/bin/bash

baseDir='/var/lib/mysql' 
# mkdir gzip
dbuser='root'
passwd='123456'

mycmd="mysql -u$dbuser -p$passwd"
for dir in $(ls ${baseDir}/20230529)
do
 # [ -d $dir ] && echo $dir
 # echo $dir;
 	result=$(echo $dir | grep ".gz")
	if [[ "$result" != "" ]]
	then
	    # 解压到 指定目录
		gzip -dk $baseDir/20230529/$dir
		mv $baseDir/20230529/$dir $baseDir/gzip/$dir
		# 
		dbname=${dir%.sql.gz}
		# 删库
    	$mycmd -e "drop database if exists $dbname;"
    	# 建库
    	$mycmd -e "CREATE DATABASE $dbname DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"
		$mycmd ${dbname} < $baseDir/20230529/${dbname}.sql
	fi
done