数据库导入脚本

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