Tuesday, February 1, 2011

batch file for creating db in wondows


Create a batch file like creatingdb.bat
copy the following code in the batch file:
cd "D:\Program Files\MySQL\MySQL Server 6.0\bin"
mysql -uroot -proot database_name < e:/database.sql

database.sql should contain the following code

drop database database_name;
create database database_name;

use database_name;

source D:\project name\sql\File.sql
source D:\project name\sql\script.sql
source D:\project name\sql\script_users.sql


No comments:

Post a Comment