1.编写database.txt,在里面写drop database dbname;
create database dbname;
2.
编写批处理文件
@echo off
set path=C:\program files\mysql\mysql server 5.5\bin
cd ./
set CURR_PATH=%cd%
mysql -h 192.168.1.130 -u root --password=123456 < database.txt
mysql -h 192.168.1.130 -u root -p xx < xx.sql --password=123456