8.0 Tickets

At the start of the month, send an email to oc@geant.org asking him to get an extract of the OTRS data and dump it onto test-msr.geant.net in the /tmp directory.

Copy the file from the /tmp directory to your laptop into a directory called c:\otrs\database.

Using 7-Zip (http://www.7-zip.org/download.html) unzip the file into the c:\otrs\database directory.

Run the Java Batch Program called SQLGenerator. This will take the very large .sql file and split it up into it's separate table files and store them in the c:\otrs\database\datafiles directory.

** Richard to distribute SQLGenerator code to team.

Before you import the data, please delete the c:\otrs\database\datafiles\header_stuff.sql

Using MYSQL Workbench, import the following tables into the otrs database on test-msr.geant.net:

dynamic_field_value

ticket

ticket_history

ticket_state

ticket_type