Okay, I'm so tired at looking at this monitor my vision is getting blurred. In mysqlman I've tried everything I can think of to import a pipe delimited text file into SQL2b5 Links table. Here is what I get:
MySQL said: Can't get stat of '/usr/local/etc/httpd/htdocs/surfsafely/textfile.txt' (Errcode: 2).
Query: LOAD DATA INFILE '/usr/local/etc/httpd/htdocs/surfsafely/textfile.txt' IGNORE INTO TABLE Links FIELDS
TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 0 LINES
(URL,Title,Description,Mod_Date)
Here's a few lines from the text file
http://www.ll.net/aho/teamaho.htm|Amateur Hockey Online's Hockey Select Site Award Winners|Amateur Hockey Online s Select Site Page for the Best of the Web in amateur hockey|952705843
http://www.llanberis.com/|Welcome to Llanberis and Snowdonia|Llanberis and Snowdonia in North Wales|973533748
http://www.llandrindod-wells.com/|Welcome to Llandrindod Wells|Llandrindod Wells Wales premier Spa Town|973194595
http://www.llandudno.com/|Welcome to Llandudno|Llandudno in North Wales|973623384
User malfunction? or script malfunction?
Mark Brasche
http://SurfSafely.com/