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-dwarehouse01.geant.net in the /msr directory.

Unzip the file using gunzip into the same directory.

Load the data into the OTRS database on test-dwarehouse01.geant.net this may take about 10 - 20 minutes due to the size of the database

mysql -uwhseUser -p otrs

source /msr/filename.sql

Log out of database and export the relevant tables:

mysqldump -uwhseUser -p otrs dynamic_field_value ticket ticket_history ticket_state ticket_type > /msr/otrs.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