Page History

...

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 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

...

. The script also exports the following tables into a file called /msr/

...

otrs.sql

Log out of database and export the relevant tables:

mysqldump -uwhseUser -p otrs dynamic_field_value 

ticket

...

ticket_history

...

ticket_state

...

ticket_type

...

Winscp the /msr/otrs.sql file onto your laptop/

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

dynamic_field_value

ticket

ticket_history

ticket_state

ticket_type.