-------------- SELECT version() -------------- +-------------------------+ | version() | +-------------------------+ | 5.0.45-community-nt-log | +-------------------------+ 1 row in set (0.00 sec) -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|' -------------- Query OK, 632722 rows affected, 65535 warnings (1 min 41.45 sec) Records: 632722 Deleted: 0 Skipped: 0 Warnings: 632744 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|' -------------- Query OK, 4163272 rows affected, 65535 warnings (5 min 42.29 sec) Records: 4163272 Deleted: 0 Skipped: 0 Warnings: 4163272 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|' -------------- Query OK, 956904 rows affected, 65535 warnings (5 min 17.35 sec) Records: 956904 Deleted: 0 Skipped: 0 Warnings: 956924 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|' -------------- Query OK, 3480754 rows affected, 65535 warnings (8 min 51.18 sec) Records: 3480754 Deleted: 0 Skipped: 0 Warnings: 878 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|' -------------- Query OK, 614931 rows affected, 65535 warnings (1 min 50.23 sec) Records: 614931 Deleted: 0 Skipped: 0 Warnings: 6 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|' -------------- Query OK, 3811904 rows affected (3 min 38.09 sec) Records: 3811904 Deleted: 0 Skipped: 0 Warnings: 0 -------------- LOAD DATA LOCAL INFILE 'l_LMpriv-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|' -------------- Query OK, 1331933 rows affected, 65535 warnings (5 min 3.72 sec) Records: 1331933 Deleted: 0 Skipped: 0 Warnings: 34 Bye