Page History

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-msrdwarehouse01.geant.net in the /tmpmsr directory.

Copy Unzip 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.

For an alternative way of extracting the relevant tables see https://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file

** Richard to distribute SQLGenerator code to team.

...

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:

...