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
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
