[otrs] Backup and Restore pearl script - success? failure?

2013-06-10 Thread Paul Simons
Has anybody successfully used the 'backup.pl' and 'restore.pl'? If so what preparation did you do before running the scripts? - new PostgreSQL database? - from template 0? - load schema before - create user, role? - etc The documentation is a little light on the preceding steps Regard

Re: [otrs] Backup and Restore pearl script - success? failure?

2013-06-10 Thread Steven Carr
Not used Postgres but with MySQL you need to prep the environment for the database i.e. create the user and database and assign permissions. Then the restore will create all the tables and restore the data. Can't say I've ever liked the idea of an all in one backup/restore script. I have MySQL

Re: [otrs] Backup and Restore pearl script - success? failure?

2013-06-10 Thread Paul Simons
[mailto:otrs-boun...@otrs.org] On Behalf Of Steven Carr Sent: Monday, June 10, 2013 5:25 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup and Restore pearl script - success? failure? Not used Postgres but with MySQL you need to prep the environment for the database i.e

Re: [otrs] Backup and Restore pearl script - success? failure?

2013-06-10 Thread Steven Carr
-Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Steven Carr Sent: Monday, June 10, 2013 5:25 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup and Restore pearl script - success? failure? Not used Postgres but with MySQL you