Hi, we were able to perform a full restore executing these steps:

1. Perform a full new OTRS install including the step through the browser (i.e: http://newserver/otrs/installer.pl).  In this step, it can be informed the correct root password that was in use in the production OTRS that crashed or let it for step 4

2. Set correct owner and group of directory /opt/otrs

3. Drop otrs database created on step 1. In our case, through mysql prompt

linux> mysql –u root –p

mysql> drop database otrs;

4. Reset otrs root password for the one used in production environment that crashed if not did in step 1

mysql> SET PASSWORD FOR ‘otrs’@’newserver’ = PASSWORD(‘<the production password>’);

5. Recreate otrs database

mysql> create database otrs;

6. Perform restore

linux> /opt/otrs/scripts/restore.pl –b <backup dir> -d /opt/otrs

                                Where <backup dir> is the path until the directory whose name is the timestamp of the backup generated, i.e, /tmp/2009-03-13_11-49

This was how we were able to do it without any errors in the restore , there may be others. Hope this helps.

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Maurice James
Sent: segunda-feira, 4 de maio de 2009 22:47
To: otrs@otrs.org
Subject: [otrs] Backup/Restore

Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup?

Any help is appreciated