[SLE] Re: MySQLd question ...

From: Kevin Donnelly (kevin_at_dotmon.com)
Date: 09/05/03

  • Next message: Thibaut Cousin: "Re: [SLE] LT winmodem problem" 
    To: suse-linux-e@suse.com
Date: Fri, 5 Sep 2003 10:33:23 +0100

    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
-- 
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: Thibaut Cousin: "Re: [SLE] LT winmodem problem"

    Relevant Pages