Do you know if the backup script has a size limit or a timeout setting? I did gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE' on my failed restore and it only displayed 4 tables article, article_attachment, article_plain, article_flag

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Frans Stekelenburg
Sent: Tuesday, May 05, 2009 5:42 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Backup/Restore

Hi Maurice,

backup.pl (and restore.pl) should enable you to do a full rebuild. I have used it to setup a shadow/test system.

However you have to make sure that:

- The backup.pl script runs without ANY errors!

- To use ‘–t fullbackup’ when do a backup to get ALL data

- The database is empty (dropped) when restoring

I usually use:

# ./backup.pl -d /opt/otrs/restore -r 20 -t fullbackup

Check the files in the output directory (-d), what files do you have?

Check the contents of the ‘DatabaseBackupo.sql.gz’ file, of the backup.

Here is how to check what tables are in the sql data file (gzip -cd DatabaseBackup.sql.gz | more):

                # cd /opt/otrs/<your restore dir>/<the backup data dir>

# gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE'

gr,

Frans

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Maurice James
Sent: dinsdag 5 mei 2009 03: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