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