the permissions on the file and the enclosing directory (all the way up
to the root dir) must allow for execution
also, my.cnf need to have
[mysqld]
local-infile=1
#!/usr/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:mysql:databasename", 'user', 'password', {
PrintError => 0 } ) or die
I just tried the following and got
ysql> load data local infile "/home/repett0/contact.data" into table
CONTACT;
ERROR 1148: The used command is not allowed with this MySQL version
mysql>
I too use perl and dbi
What is going on?
Thanks
Ron
I have found to do a LOAD DATA LOCAL INFILE is no longer possible
using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld],
and [client] sections of my.cnf.
I am not sure what prompted the engineering powers-that-be to
change the default for this version, 3.23.49, of mysql, but it
Sorin,
Saturday, October 05, 2002, 8:33:23 AM, you wrote:
SC> 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
SC> file?
SC> My.ini file is below:
SC> [mysqld]
SC> basedir=C:/mysql
SC> datadir=C:/mysql/data
SC> enable-local-infile
SC> local_infile=1
SC> When I perform th
1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
file?
My.ini file is below:
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
enable-local-infile
local_infile=1
When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
from a client application using MyOBDC
