move data to new system

[netjess]

Hello,

I need to move my data to a new system.
I am moving it off from a vAppliance to a full self built system on Ubuntu 14 with Apache2 and PostgreSQL.
I would appreciate some input.
Should I build out the system first and let the install build the database then import data or should I set up data using my psql_dump file and then attach to that data?

Also, are attachments to tickets stored in database?

If you know any gottchas to look out for please let me know.

Thank you much.

[netjess]

looking at my appliance it apears to be version 4.0.11
I built latest stable at version 4.0.13.

I dumped from appliance "pg_dump -h 127.0.0.1 otrs > otrs_backup.psql" and it produced a 3GB file.

When I try to import data (on new server) "psql -h 127.0.0.1 -U postgres -W otrs < otrs_backup.psql", I get a LOT of errors about invalid command and like "ERROR: relation "ticket_id_seq" does not exist".

I made a backup of the base db before trying to import. and after failed import of appliance data. I can empty the database and restore the public schema and then import the base backup and it works just fine.

% "psql -h 127.0.0.1 -U postgres -W otrs"
# DROP SCHEMA PUBLIC;
# CREATE SCHEMA PUBLIC;
#\quit
% "psql -h 127.0.0.1 -U postgres -W otrs < otrs_base_backup.psql"

This gets no errors.

Thank you for assistance.

[netjess]

I was able to get my data moved to the new system.

I used the backup and restore scripts in otrs
/SOURCE/SHARE/var/otrs/scripts/backup.pl -d /BACKUP

move files to new system, then:
/opt/otrs/scripts/restore.pl -b backup/ -d /opt/otrs/

I then deleted basic otrs database created during setup and created a new empty database.
Then I imported data created by backup.pl:
psql -h 127.0.0.1 -U postgres -W otrs < DatabaseBackup.sql

Restarted apache and otrs Cron and I was able to log in.

The only thing I see wrong is that my custom Queues are gone. Only the default queues are present.

[netjess]

Well, not sure what the deal was, but I was clicking around and saw that my custom queues were listed under "Manage Template-Queue Relations".
I clicked on a couple queues to check them and when I went back to the "Manage Queues" area all of my queues were there.

But now if I close a ticket I get errors like the following in SysLog:
ERROR: invalid byte sequence for encoding "UTF8": 0xa0, SQL: 'INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_message_id_md5, a_in_reply_to, a_references, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,


Sigh, maybe I'll just tell them we have to start with a fresh system.