包括在bat中执行建库建表命令,导入csv格式数据等。
m.bat
@@echo off
set errorlevel=0
set path_home_mysql=C:\Program Files\MySQL\MySQL Server 5.0\
set path_bin_mysql="C:\Program Files\MySQL\MySQL Server 5.0\bin\"
echo %path_bin_mysql%
set user_mysql=root
set password_mysql=password
%path_bin_mysql%mysql -u%user_mysql% -p%password_mysql% <c:/msn.sql
echo end backup
set errorlevel=0
set path_home_mysql=C:\Program Files\MySQL\MySQL Server 5.0\
set path_bin_mysql="C:\Program Files\MySQL\MySQL Server 5.0\bin\"
echo %path_bin_mysql%
set database_mysql=msn
set user_mysql=root
set password_mysql= password
%path_bin_mysql%mysql.exe -u%user_mysql% -p%password_mysql% %database_mysql%< mytestsql.sql
echo end backup
m.sql
就是用Mysql-Frong导出的包含表结构的sql文件,略去。
Mytestsql.sql
load data local infile 'E:\\DBfiles\\list.csv' into table list fields terminated by ',';