[SLE] Re: MySQLd question ...

From: James Hatridge (James.Hatridge_at_epost.de)
Date: 09/05/03

  • Next message: Turd Ferguson: "[SLE] MiniDV Capture Under Linux" 
    To: kevin@dotmon.com, suse-linux-e@suse.com
Date: Fri, 5 Sep 2003 20:04:13 +0200

    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. 
-- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com
  • Next message: Turd Ferguson: "[SLE] MiniDV Capture Under Linux"