--------------
SELECT version()
--------------

+---------------------+
| version()           |
+---------------------+
| 5.1.28-rc-community | 
+---------------------+
1 row in set (0.00 sec)

--------------
LOAD DATA LOCAL INFILE 'l_coast-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|'
--------------

Query OK, 5898 rows affected, 5898 warnings (0.06 sec)
Records: 5898  Deleted: 0  Skipped: 0  Warnings: 5898

--------------
LOAD DATA LOCAL INFILE 'l_coast-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|'
--------------

Query OK, 88850 rows affected, 65535 warnings (0.66 sec)
Records: 88850  Deleted: 0  Skipped: 0  Warnings: 88850

--------------
LOAD DATA LOCAL INFILE 'l_coast-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|'
--------------

Query OK, 42466 rows affected, 42466 warnings (0.63 sec)
Records: 42466  Deleted: 0  Skipped: 0  Warnings: 42466

--------------
LOAD DATA LOCAL INFILE 'l_coast-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|'
--------------

Query OK, 85152 rows affected, 65535 warnings (1.50 sec)
Records: 85152  Deleted: 0  Skipped: 0  Warnings: 0

--------------
LOAD DATA LOCAL INFILE 'l_coast-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|'
--------------

Query OK, 28915 rows affected, 28915 warnings (0.45 sec)
Records: 28915  Deleted: 0  Skipped: 0  Warnings: 0

--------------
LOAD DATA LOCAL INFILE 'l_coast-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|'
--------------

Query OK, 140586 rows affected, 65535 warnings (0.69 sec)
Records: 140586  Deleted: 0  Skipped: 0  Warnings: 140586

--------------
LOAD DATA LOCAL INFILE 'l_coast-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|'
--------------

Query OK, 29557 rows affected, 65535 warnings (0.75 sec)
Records: 29557  Deleted: 0  Skipped: 0  Warnings: 0

Bye