8.0 Tickets

At the start of the month, send an email to oc@geant.org asking them to export the OTRS database - they have instructions for this. Currently they put it on test-msr.geant.net in the /tmp/ directory, it would be better if we get them to export it to test-dwarehouse01.geant.net in the /msr directory.

Unzip the file using gunzip into the same directory.

Rename the file to /msr/DatabaseBackup.sql

Run the script /msr/splitsql.sh 

This will split the very large DatabaseBackup.sql into seperate .sql files in the /msr/datafiles directory. The script takes about 3 minutes to complete.

Now run the script /msr/dataload.sh

This loads 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. The script also exports the following tables into a file called /msr/otrs.sql

dynamic_field_value

ticket

ticket_history

ticket_state

ticket_type

Log into test-msr.geant.net and scp the file from test-dwarehouse01.geant.net:/msr/otrs.sql :

scp test-dwarehouse01.geant.net:/msr/otrs.sql /tmp/

Load the sql into the otrs database using the reportsUser user:

mysql -ureportsUser -p otrs < /tmp/otrs.sql

Using MYSQL Workbench, import the otrs.sql file into the otrs database on test-msr.geant.net.