Questions regarding backups on Windows XP

Moderator: crythias

Locked
Burori
Znuny newbie
Posts: 12
Joined: 06 Sep 2011, 18:40
Znuny Version: 3.0.7

Questions regarding backups on Windows XP

Post by Burori »

Hello,

I noticed a few articles regarding backing up your OTRS on Windows servers and such however I have yet to find one regarding windows XP.

Currently at the company that I work with we use OTRS on windows XP. My trouble right now is trying to figure out a simple method on making backups of our emails that get pulled into the ticketing system that as I understand it, someone mentioned it would become articles.

I have looked through the system in the folders to see if there was a specific location where this information is stored and I was unable to find anything that could help with making this backup. I have read through the manual for assistance but the only information that it provided was Linux commands to create backups and I am aware that Linux commands will not work with Windows.

We installed the Otrs using the Windows installer otrs4win on the site.

The only successful means of making a backup as I saw it currently was to make a copy of the C:/program files/Otrs folder. Is there another way to perform this using Dos or any type of program that can make a backup of only the emails/articles with the system configuration of the OTRS?

Any help would be greatly appreciated.
OTRS 3.0.7 on Windows XP with MySQL database + Perl + Apache
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Questions regarding backups on Windows XP

Post by crythias »

The backup methodology is agnostic (doesn't matter) to the host operating system.

As far as OTRS is concerned, once OTRS grabs them, they are no longer emails, but have been converted to tickets.

The "backup" is simply a mysqldump of these tickets and not extractable as emails.

A "full backup" is available through the backup.pl ... read the docs.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Burori
Znuny newbie
Posts: 12
Joined: 06 Sep 2011, 18:40
Znuny Version: 3.0.7

Re: Questions regarding backups on Windows XP

Post by Burori »

Thank you for the quick response.

Forgive me if this sounds very noobish, but is there a site or can you provide basic commands to help me understand how to perform a Mysqldump? I am having trouble understanding how to perform this function.

Thanks again for the assistance.
OTRS 3.0.7 on Windows XP with MySQL database + Perl + Apache
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Questions regarding backups on Windows XP

Post by crythias »

OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Burori
Znuny newbie
Posts: 12
Joined: 06 Sep 2011, 18:40
Znuny Version: 3.0.7

Re: Questions regarding backups on Windows XP

Post by Burori »

Ok,

Not to sound rude but that was entirely unhelpful.

Thanks but no thanks I will not need any further assistance.
OTRS 3.0.7 on Windows XP with MySQL database + Perl + Apache
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Questions regarding backups on Windows XP

Post by crythias »

linux:/opt/otrs/scripts# ./backup.pl -d /backup/
=
In XP:
open a command prompt
cd C:\Program Files\Otrs\Otrs\Scripts
type
perl backup.pl -d c:\path\to\where\you\want\backup

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
mysqldump otrsdatabasename -uotrsdbusername -potrsdbpassword > otrsbackup.sql
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kettysimpson
Znuny newbie
Posts: 4
Joined: 07 Dec 2011, 18:51
Znuny Version: 11.2

Re: Questions regarding backups on Windows XP

Post by kettysimpson »

For the OTRS backup you will have to make SQL dump first of all. After that copy the complete OTRS directory. Than for a restore the backup reinstall OTRS package copy back the OTRS directory and than reload the sql backup in mysql database. And for downloading the settings Download all system config changes." and the Load Settings in [SysConfig]
gabar82
Znuny newbie
Posts: 61
Joined: 27 Sep 2012, 09:26
Znuny Version: 3.1.6

Re: Questions regarding backups on Windows XP

Post by gabar82 »

hi

i have try perl backup.pl -d c:\path\to\where\you\want\backup

but system reply:

WHICH not Which is not recognized as an internal or external command, operable program or batch file
ERROR: Can't locale cp!
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Questions regarding backups on Windows XP

Post by jojo »

the backupo.pl script is only for unix based systems
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
gabar82
Znuny newbie
Posts: 61
Joined: 27 Sep 2012, 09:26
Znuny Version: 3.1.6

Re: Questions regarding backups on Windows XP

Post by gabar82 »

jojo wrote:the backupo.pl script is only for unix based systems
how can I do to run the backup on windows 2008 server?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Questions regarding backups on Windows XP

Post by jojo »

you need to backup the OTRS directory and create a mysqldump
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
gabar82
Znuny newbie
Posts: 61
Joined: 27 Sep 2012, 09:26
Znuny Version: 3.1.6

Re: Questions regarding backups on Windows XP

Post by gabar82 »

jojo wrote:you need to backup the OTRS directory and create a mysqldump
How do I create a backup?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Questions regarding backups on Windows XP

Post by jojo »

any kind of windows based backup software might help. Your IT department should be able to provide you more details
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
gabar82
Znuny newbie
Posts: 61
Joined: 27 Sep 2012, 09:26
Znuny Version: 3.1.6

Re: Questions regarding backups on Windows XP

Post by gabar82 »

jojo wrote:any kind of windows based backup software might help. Your IT department should be able to provide you more details

ok i think maybe backup with windows backup.


and how to i crete mysqldump ?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Questions regarding backups on Windows XP

Post by jojo »

with the mysldump exe

or have a look here http://www.zmanda.com/index.html
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked