I have had luck by removing the word LOCAL from the statement. -=Bryan=-
> -----Original Message----- > From: nellA hciR [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 11:33 AM > To: MySQL List > Subject: load data local infile > > > i have read several archives/docs on this but still can not > get this to > work > > from the mysql command line, load data local infile DOES > work, am trying to get this to work from Perl > > $sth = $dbh->prepare("load data local infile > '/users/hcir/desktop/t2/0001' into table s0001"); > $sth->execute() or warn " : $DBI::errstr\n"; > > returns > The used command is not allowed with this MySQL version > > Mac OS X mysql 4.0.3 > > /etc/my.cnf contains > [mysqld] > local-infile=1 > > [mysql] > local-infile=1 > > thanks > - hcir > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
