Hi Kevin et al.... OK, I've got a bit more done. I was useing "load data local infile" you are using "load data infile". So I dropped "local" I am now getting this error, any ideas? mysql> load data infile "/home/hatridge/public_html/Datebase/euroUSA1.txt" into table Money_USA; ERROR 13: Can't get stat of '/home/hatridge/public_html/Datebase/euroUSA1.txt' (Errcode: 2) Thanks JIM On Friday 05 September 2003 11:33, Kevin Donnelly wrote:
On Thursday 04 September 2003 17:53, James Hatridge wrote:
Thanks for the idea, but it did not help at all. What I am trying to do is to get the "Load data local infile" working. To get this working I have to add "-- local-infile=1" as an option to mysqld when I boot the system.
My problem is WHERE do I put that !"§$! thing? I've been fiddling with this for the past 2-3 days.
Strange - I have used just this command in a script on a stock 8.2 install, and it was OK.
The line in the PHP script was: $sql=" load data infile '$sales_upd' into table $tmptable fields terminated by ',' enclosed by '\"' ignore 1 lines (dist,code,sagedate,partno,quantity,value,analysis) "; Change the two variables to real names (and amend the column definitions of course), and you should be able to type this directly into phpMyAdmin (or mysql if you use the dash notation) and get a result.
IIRC, it did take a few tries with the "fields terminated by ..." to get the right combination, but that is a minor issue. Start working with a representative set of around 20 records, and see what you get.
If you make no headway, you'll have to be a bit more specific about your setup, what you've tried, and your data.
--
Best wishes
Kevin Donnelly
www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Jim Hatridge Linux User #88484 -- Our country was colonized by the religious, political, economic, and criminal rejects of every country in the world. We have been carefully breeding insane, obsessive, fanatic lunatics with each other for over 400 years, resulting in the glorious strain of humanity known as "Americans". You have to expect some... peculiarities.