simple batch script to import sql file in mysql

 
@echo off
SET mysqldir=C:\mysql\bin
SET mysqlhost=localhost
SET mysqldatabase=dbname
SET mysqluser=user
SET mysqlpassword=password

if [%1]==[] goto usage

IF NOT EXIST %1 GOTO nosuchfile

@REM Change to mysqldir
REM CD %mysqldir%

@REM importing db
"%mysqldir%\mysql.exe" -u %mysqluser% -h%mysqlhost% -p%mysqlpassword% %mysqldatabase% < %1


pause
goto end


:usage
echo -How to use-
echo EXAMPLE:
echo %0 sqlfile.sql
goto end
:nosuchfile
echo --ERROR--
echo no such file %1

:end