@echo off
setlocal
set backup_dir=C:\backup_OTRS

echo -----------------------------------
echo  Restore OTRS + settings + database 
echo  V1.0 - 26 mei 2010               
echo -----------------------------------
echo.

echo Create backup directory "%backup_dir%" and copy files
md %backup_dir%
xcopy /E . %backup_dir% /Q /Y
pause

echo -----------------------------------
echo Start OTRS installer !! skip web installer !!
"%backup_dir%\otrs-2.4.7-win-installer-2.1.1.exe"
pause

echo -----------------------------------
echo Copy OTRS directory
xcopy /E %backup_dir%\OTRS "%ProgramFiles%\OTRS\OTRS" /Q /Y
pause

echo -----------------------------------
echo Restore sql database
"%ProgramFiles%\OTRS\MySQL\bin\mysql.exe" -uroot < "%backup_dir%\otrsdump.sql"
pause

echo -----------------------------------
echo Copy crontab
copy "%backup_dir%\CRONw\crontab.txt" "%ProgramFiles%\OTRS\CRONw" /Y
pause

echo.
echo Ready - Reboot the PC !!!!
echo -----------------------------------
pause