mysql 数据恢复 Shell 脚本

mysql_restore.sh

#!/bin/sh

function restore(){
	cd /var/tmp/ 
	tar zxvf sql.tar.gz
	for databaseName in $*
	do
		sqlFileName=""$databaseName".sql"
		echo "importing "$databaseName 

		# 导入数据库
		mysql -uuser -ppassword $databaseName < sql/$sqlFileName
	done
	echo '数据备份完成'
	
}

restore 'site1.cn' 'site2.com'