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