----- Forwarded message from "Vancura, Mark D (Mark)" <mark.vanc...@lsi.com>
-----
Date: Thu, 9 May 2013 11:05:37 -0400
From: "Vancura, Mark D (Mark)" <mark.vanc...@lsi.com>
To: "tim.bu...@pobox.com" <tim.bu...@pobox.com>
Subject: Perl DBI question
Tim,
I am newly trying to make Perl and DBI work with mysql, with some success,
e.g. I have been
able to get connected, accessing a database, and create a table in it, with
this command:
MySQL_command = create table ports (
PortName varchar(40),
direction enum('input','output','inout'),
digital_analog enum('digital','analog'),
port_pad enum('port','pad'),
powerSupplies varchar(20) ) ;
executed create table command
However, then I want to put data into it, with a command like the following:
load data local infile 'TEMP_LOAD_DATA_26021' into table ports ;
And I get:
DBD::mysql::db do failed: The used command is not allowed with this MySQL
version at
read_excel_write_mysql.pl line 140.
DBD::mysql::db do failed: The used command is not allowed with this MySQL
version at
read_excel_write_mysql.pl line 140.
Whether I "do" it or "prepare" and then "execute" it.
If I run /usr/bin/mysql interactively, these commands are completely
successful, so it hardly seems like
a "MySQL version" issue.
But I also have not been able to find that message in any of the DBI/DBD
code, thus I suspect part of it
is coming from MySQL.
Is there some permission issue related to "Load data local infile" that I
can/must manage. I am
currently running as the "root" of
mysql, and thus I expect I have, or can get any permission necessary.
Thanks for any help you can provide.
Mark Vancura
LSI Corporation.
----- End forwarded message -----
