(Fwd) Perl DBI question

----- Forwarded message from "Vancura, Mark D (Mark)" <[email protected]> -----

Date: Thu, 9 May 2013 11:05:37 -0400
From: "Vancura, Mark D (Mark)" <[email protected]>
To: "[email protected]" <[email protected]>
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 -----