Command Prompt (cmd.exe) version

refresh_database.bat

@echo off

SET DUMP_FILE_LOCATION=doc\database.sql
SET MYSQL=c:\xampp\mysql\bin\mysql.exe
SET MYSQLDUMP=c:\xampp\mysql\bin\mysqldump.exe
IF "%1"=="" GOTO ERROR
SET DATABASE_NAME="%1"
IF "%2"=="--dump" GOTO :DUMP


:RESTORE
echo Dropping database %DATABASE_NAME%
%MYSQL% -u root -e "drop database %DATABASE_NAME%"

echo Creating database %DATABASE_NAME%
%MYSQL% -u root -e "create database %DATABASE_NAME%"

echo Importing doc/database.sql
%MYSQL% -u root %DATABASE_NAME% < %DUMP_FILE_LOCATION%

GOTO END


:DUMP 
echo Dumping database %DATABASE_NAME%
%MYSQLDUMP% -u root %DATABASE_NAME% > %DUMP_FILE_LOCATION%
GOTO END

:ERROR 
echo please give database name

:END