-------------- SELECT version() -------------- +---------------------+ | version() | +---------------------+ | 5.1.28-rc-community | +---------------------+ 1 row in set (0.00 sec) -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|' -------------- Query OK, 73716 rows affected, 65535 warnings (0.50 sec) Records: 73716 Deleted: 0 Skipped: 0 Warnings: 73716 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|' -------------- Query OK, 11460297 rows affected, 65535 warnings (1 min 23.94 sec) Records: 11460297 Deleted: 0 Skipped: 0 Warnings: 11460297 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|' -------------- Query OK, 107072 rows affected, 65535 warnings (1.64 sec) Records: 107072 Deleted: 0 Skipped: 0 Warnings: 107072 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|' -------------- Query OK, 3989984 rows affected, 65535 warnings (1 min 2.73 sec) Records: 3989984 Deleted: 0 Skipped: 0 Warnings: 12 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|' -------------- Query OK, 75219 rows affected, 65535 warnings (1.25 sec) Records: 75219 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|' -------------- Query OK, 710880 rows affected (2.41 sec) Records: 710880 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMcomm-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|' -------------- Query OK, 173878 rows affected, 65535 warnings (4.34 sec) Records: 173878 Deleted: 0 Skipped: 0 Warnings: 0 Bye