List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 22 2002 1:16am
Subject:Re: Perl/DBI & load data local
View as plain text  
At 10:23 -0800 6/21/02, nellA hciR wrote:
>iH
>
>running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and 
>am able to use the "load data local file" command when running run 
>the interactive mysql app (command line).
>
>my problem is that i can not use the "load data local" command from 
>a Perl script. i am connecting as the same user and i do with the 
>command line. other command such as connect, disconnect, insert, 
>select do work
>
>what am i missing to allow the same access via Perl as with the command line

Add:

	;mysql_read_default_group=client

to the end of your DSN string.

>
>thanks
>- hcir
>g3pb@stripped

Thread
Perl/DBI & load data localnellA hciR21 Jun
  • Re: Perl/DBI & load data localPaul DuBois22 Jun