I got bored typing mysql commands so wrote a little script to keep on my box for easy access to restore databases from .sql files.
It’s very simple and may not be any use to anyone. It also stores the root password in plain text so use it at your own risk!
@echo off
IF %1.==. GOTO No1
IF %2.==. GOTO No2
ECHO Dave’s mySQL Database Restore Utility
ECHO ————————————-
ECHO Restoring Database %1
ECHO ————————————-
“C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe” -uroot -pPASSWORD %1 < %2
ECHO Done
GOTO End1
:No1
ECHO No database Sepecified
ECHO use: rmsql.bat DATABASENAME .SQLFILE
GOTO End1
:No2
ECHO No .sql file specified
ECHO use: rmsql.bat DATABASENAME .SQLFILE
GOTO End1
:End1