Bruce, Thanks, the explanation makes sense, so I need to figure out how to follow through on this documented suggestion from: 6.1.6. Security Issues with LOAD DATA LOCAL
*If you use LOAD DATA LOCAL in Perl scripts or other programs that read the [client] group from option files, you can add the local-infile=1 option to that group. However, to keep this from causing problems for programs that do not understand local-infile, specify it using the loose- prefix: [client] loose-local-infile=1 *If LOAD DATA LOCAL is disabled, either in the server or the client, a client that attempts to issue such a statement receives the following error message: ERROR 1148: The used command is not allowed with this MySQL version Thus this fits my situation exactly, I just have to learn where the "option files" are and how to put the [client] loose-local-infile=1 into it. Any suggestions where to look this up? Thanks again for your help with this! Mark Vancura -----Original Message----- From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu] Sent: Thursday, May 09, 2013 11:26 AM To: dbi-users@perl.org (dbi-users@perl.org) Subject: Re: (Fwd) Perl DBI question On May 9, 2013, at 9:37 AM, tim.bu...@pobox.com 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
