Re: [otrs] Backup/Restore

5 May 2009

      Hi,

                Is this all of the out put that I should see from the gzip
command?

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

CREATE TABLE `article` (

CREATE TABLE `article_attachment` (

CREATE TABLE `article_flag` (

CREATE TABLE `article_plain` (

CREATE TABLE `article_search` (

CREATE TABLE `article_sender_type` (

CREATE TABLE `article_type` (

CREATE TABLE `auto_response` (

CREATE TABLE `auto_response_type` (

CREATE TABLE `bench_test` (

CREATE TABLE `calendar_event` (

CREATE TABLE `calendar_event_involved` (

CREATE TABLE `customer_company` (

CREATE TABLE `customer_preferences` (

CREATE TABLE `customer_user` (

CREATE TABLE `faq_attachment` (

CREATE TABLE `faq_category` (

CREATE TABLE `faq_category_group` (

CREATE TABLE `faq_history` (

CREATE TABLE `faq_item` (

CREATE TABLE `faq_language` (

CREATE TABLE `faq_log` (

CREATE TABLE `faq_state` (

CREATE TABLE `faq_state_type` (

CREATE TABLE `faq_voting` (

CREATE TABLE `follow_up_possible` (

CREATE TABLE `generic_agent_jobs` (

CREATE TABLE `group_customer_user` (

CREATE TABLE `group_role` (

CREATE TABLE `group_user` (

CREATE TABLE `groups` (

CREATE TABLE `link_object` (

CREATE TABLE `link_relation` (

CREATE TABLE `link_state` (

CREATE TABLE `link_type` (

CREATE TABLE `mail_account` (

CREATE TABLE `notifications` (

CREATE TABLE `object_link` (

CREATE TABLE `package_repository` (

CREATE TABLE `personal_queues` (

CREATE TABLE `postmaster_filter` (

CREATE TABLE `process_id` (

CREATE TABLE `queue` (

CREATE TABLE `queue_auto_response` (

CREATE TABLE `queue_preferences` (

CREATE TABLE `queue_standard_response` (

CREATE TABLE `role_user` (

CREATE TABLE `roles` (

CREATE TABLE `salutation` (

CREATE TABLE `search_profile` (

CREATE TABLE `service` (

CREATE TABLE `service_customer_user` (

CREATE TABLE `service_sla` (

CREATE TABLE `sessions` (

CREATE TABLE `signature` (

CREATE TABLE `sla` (

CREATE TABLE `standard_attachment` (

CREATE TABLE `standard_response` (

CREATE TABLE `standard_response_attachment` (

CREATE TABLE `support_bench_test` (

CREATE TABLE `system_address` (

CREATE TABLE `theme` (

CREATE TABLE `ticket` (

CREATE TABLE `ticket_history` (

CREATE TABLE `ticket_history_type` (

CREATE TABLE `ticket_index` (

CREATE TABLE `ticket_lock_index` (

CREATE TABLE `ticket_lock_type` (

CREATE TABLE `ticket_loop_protection` (

CREATE TABLE `ticket_priority` (

CREATE TABLE `ticket_state` (

CREATE TABLE `ticket_state_type` (

CREATE TABLE `ticket_type` (

CREATE TABLE `ticket_watcher` (

CREATE TABLE `time_accounting` (

CREATE TABLE `user_preferences` (

CREATE TABLE `users` (

CREATE TABLE `valid` (

CREATE TABLE `web_upload_cache` (

CREATE TABLE `xml_storage` (

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