Hi
I use the following script [bat] file. It makes a mysql backup and
copy/backup the otrs directory
Steps
1. Create a text file and change the extension to .bat
2. Change the contents to do your backup
:: ##### Begin #####
For /f "tokens=1-4 delims=/ " %%a in ('date /t') do (set dt=%%c%%a%%b)
SET date=%dt%
::Step 1
:: create a new directory to make the backup in
:: the directory wil have today's date
Mkdir C:\Backup\OTRS\%date%
:: Step 2
:: Copy OTRS Data to created directory
:: NOTE I use robocopy but u can use xcopy, copy, rsync etc - please change
accordingly
Robocopy C:\OTRS\otrs C:\Backup\OTRS\%date% /E /R:0 /W:0
:: Step 3
:: Do MYSQL backup
:: Make sure you supply the correct username and password below
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set dt=%%c-%%a-%%b)
For /f "tokens=1-4 delims=:." %%a in ('echo %time%') do (set
tm=%%a%%b%%c%%d)
set bkupfilename=mysql%1%dt%%tm%.bak
echo Backing up to file: %bkupfilename%
C:\OTRS\mysql\bin\mysqldump --databases otrs --user=root --password=password
> C:\Backup\OTRS\%date%\"%bkupfilename%"
::Step 4
:: You can get this from http://www.7zip.org - you need the command line one
:: 7-Zip The data to save lots of space
"C:\Program Files\7-Zip\7z" a -r C:\Backup\OTRS\%date%
C:\Backup\OTRS\%date%
:: Step 5
:: Delete the directory - keep the zip file, you do not need the directory
any more, tomorrow a new one will be created
RMDIR C:\Backup\OTRS\%date% /S /Q
:: ##### End #####
3. Now create a schedule for the file you created
On XP go to START | CONTROL PANEL - Look for Scheduled Tasks
-Follow the steps on screen to create the Scheduled Task
-Tip: You must supply a password [with the user] or it will not run
4. Please, please check the stuff to ensure that you have made a complete,
correct backup of your data.
You will need to clean up the backups now and then.
I hope this helps
Theuns Smuts
[EMAIL PROTECTED]
Tel: +27 21 fax: 021-8868276
www.itblue.co.za
Your preferred IT partner
Confidentiality Notice:
The information in this document and attachments is confidential and may be
legally privileged. It is intended only for the use of the named recipient.
Internet communications are not secure and therefore ITBlue does not accept
legal responsibility for the contents of this message. If you are not the
intended recipient, please notify us immediately by return email and then
delete this document. Do not disclose the contents of this document to any
other person, nor take any copies. Violation of this notice may be unlawful.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nils
Breunese (Lemonbit)
Sent: 17 October 2006 10:35
To: User questions and discussions about OTRS.org
Subject: [SPAM] LOW * Re: [otrs] Upgrade from 2.0.4 to 2.1 on Windows
platform
Eugene Colesnicov wrote:
> Ok, but how I can backup mysql database on a windows platform?
I'm guessing the Windows version of MySQL also has mysqldump (http://
dev.mysql.com/doc/refman/4.1/en/mysqldump.html), which would take of this.
You can always install something like phpMyAdmin (http://
www.phpmyadmin.net/) if you're not too comfortable with MySQL commands.
Nils Breunese.
_______________________________________________
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
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
_______________________________________________
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
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
