SQL to upload the two big MOT data files to a MySQL database, requires the tables to by using the MyIASM engine.

MOT_upload_big_files.sql

USE MOT;

ALTER TABLE testitem DISABLE KEYS;

LOAD DATA LOCAL INFILE '[yourpath \\ separated in Windows]UAT_test_item_2011.txt'
INTO TABLE testitem
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
;

ALTER TABLE testitem ENABLE KEYS;

ALTER TABLE testresult DISABLE KEYS;

LOAD DATA LOCAL INFILE '[yourpath \\ separated in Windows]UAT_test_result_2011.txt'
INTO TABLE testresult
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
;

ALTER TABLE testresult ENABLE KEYS;