Hi,
I made some scripts to backup and restore on a W2000 server.
See attachments
USE IT AT YOUR OWN RISK - NO WARRANTY - NO QUESTIONS
- cnage the extention from .txt. to .cmd
- To autobackup run it from crontab
- The windows installer is needed to restore
!!!! Do a testrun before use it in production environment!!!!!
Met vriendelijke groet / Gruß / Best Regards,
Jurjen Verhoeff
_____
From: Joseph Thomas [mailto:[email protected]]
Sent: vrijdag 3 september 2010 11:45
To: User questions and discussions about OTRS.
Subject: [otrs] Back Up and Restore??
Hai,
can any one help me.....
i want to do the back up and restore of OTRS that installed in Windows
Server 2008.
It will be very helpfull for me.
--
MAILTO="r...@localhost"
0 13,16 * * * c:/backup_OTRS/backup.cmd > c:/backup_OTRS/cron_backup.log
*/10 * * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/GenericAgent.pl -c db
*/20 * * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/GenericAgent.pl
45 */2 * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/PendingJobs.pl
10 0 * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/otrs.cleanup
*/10 * * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/PostMasterMailbox.pl
01 01 * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/RebuildTicketIndex.pl
55 */2 * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/DeleteSessionIDs.pl --expired
35 * * * * C:/PROGRA~1/OTRS/StrawberryPerl/perl/bin/perl.exe
C:/PROGRA~1/OTRS/OTRS/bin/UnlockTickets.pl --timeout
@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
@echo off
setlocal
set backup_dir=c:\backup_OTRS
echo Start execution backup: > %backup_dir%\backup.log
date /T >> %backup_dir%\backup.log
time /T >> %backup_dir%\backup.log
echo runas %USERNAME% >> %backup_dir%\backup.log
echo -----------------------------------
echo Backup OTRS + database + settings
echo V1.1 - 29 juli 2010
echo -----------------------------------
echo.
echo Create %backup_dir% and %backup_dir%\OTRS
md %backup_dir%
md %backup_dir%\CRONw
md %backup_dir%\OTRS
echo -----------------------------------
echo Dump sql database to: %backup_dir%
"%ProgramFiles%\OTRS\MySQL\bin\mysqldump.exe" --all-databases >
%backup_dir%\otrsdump.sql -u root
echo -----------------------------------
echo Copy OTRS directory to: %backup_dir%
xcopy /E "%ProgramFiles%\OTRS\OTRS" %backup_dir%\OTRS /Q /Y
echo -----------------------------------
echo Copy crontab to: %backup_dir%\CRONw
copy "%ProgramFiles%\OTRS\CRONw\crontab.txt" %backup_dir%\CRONw /Y
echo -----------------------------------
echo Copy %backup_dir% to backup server
NET USE v: /DELETE 1>>%backup_dir%\backup.log 2>&1
NET USE v: "\\W2kserver\OTRS backup" password /USER:domain\user
1>>%backup_dir%\backup.log 2>&1
xcopy %backup_dir% v: /E /Y
NET USE v: /DELETE 1>>%backup_dir%\backup.log 2>&1
echo.
echo Ready
echo -----------------------------------
echo end backup: >> %backup_dir%\backup.log
date /T >> %backup_dir%\backup.log
time /T >> %backup_dir%\backup.log
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
