-------------- SELECT version() -------------- +-------------------------+ | version() | +-------------------------+ | 5.0.45-community-nt-log | +-------------------------+ 1 row in set (0.00 sec) -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|' -------------- Query OK, 73580 rows affected, 65535 warnings (5.36 sec) Records: 73580 Deleted: 0 Skipped: 0 Warnings: 73580 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|' -------------- Query OK, 12458974 rows affected, 65535 warnings (17 min 32.73 sec) Records: 12458974 Deleted: 0 Skipped: 0 Warnings: 12458974 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|' -------------- Query OK, 105823 rows affected, 65535 warnings (37.70 sec) Records: 105823 Deleted: 0 Skipped: 0 Warnings: 105823 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|' -------------- Query OK, 4324153 rows affected, 65535 warnings (10 min 55.65 sec) Records: 4324153 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|' -------------- Query OK, 74700 rows affected, 65535 warnings (15.42 sec) Records: 74700 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|' -------------- Query OK, 649470 rows affected (38.38 sec) Records: 649470 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|' -------------- Query OK, 173118 rows affected, 65535 warnings (38.70 sec) Records: 173118 Deleted: 0 Skipped: 0 Warnings: 0 Bye