Re: Perl/DBI load data local

[Paul DuBois]

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
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Perl/DBI load data local

[nellA hciR]

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

thanks
- hcir
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php