Re: (Fwd) Perl DBI question

On May 9, 2013, at 9:37 AM, [email protected] wrote:

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

I find this in the MySQL docs:

"If the statement fails, it is likely that your MySQL installation does not have local file capability enabled by default. See Section 6.1.6, “Security Issues with LOAD DATA LOCAL”, for information on how to change this."

<http://dev.mysql.com/doc/refman/5.0/en/loading-tables.html>

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs