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
