LOAD DATA LOCAL INFILE and Perl DBI/DBD

From: Jami Bradley (jbradley_at_isa-og.com)
Date: 06/23/04

  • Next message: Daniel Miller: "math::trulyrandom" 
    Date: Wed, 23 Jun 2004 15:43:03 -0600

    HI all,

    For the past several months we have been using LOAD DATA LOCAL INFILE to bulk load tables within
    Perl modules.

    Recently, someone thought it would be a good idea to upgrade the Solaris machines - I'm thinking it
    wasn't that good an idea :-(

    We are now running MySQL 4.0.18 and the DBI version is 1.35. Now, our scripts are failing with the
    dreaded "The used command is not allowed with this MySQL version" message. Here's what I know at
    the moment:

    1. mysqld has local infile enabled.
    2. mysql client can perform a LOAD DATA LOCAL INFILE
    3. dbimon cannot perform a LOAD DATA LOCAL INFILE (same message as above).

    So as I understand this, DBI is somehow not allowing the local option. I tried adding the
    local_infile=1 option on the DSN, but that didn't help (if there was an error, it was silently
    ignored).

    Two questions:
    1. How can I get the LOCAL option working?
    2. How can I identify the source of the problem better so we don't waste more time in the future?

    Thanks!

    Jami

  • Next message: Daniel Miller: "math::trulyrandom"

    Relevant Pages

    • Re: LOAD DATA LOCAL INFILE and Perl DBI/DBD
      ... we had to code the module to shell out to mysql and execute each of the ... commands. ... >For the past several months we have been using LOAD DATA LOCAL INFILE to bulk load tables within ...
      (comp.lang.perl.modules)
    • equivalent of "load data local infile" of Mysql?
      ... i'm looking after an equivalent T-sql command as "load data local infile ... of Mysql, in order to import a textfile into sql server express 2005 ...
      (microsoft.public.sqlserver.connect)
    • mysql "LOAD DATA" equivalent in Oracle?
      ... I am using the query in MySql to import data from a tabular file: ... LOAD DATA LOCAL INFILE '/file1.tab' ... INTO TABLE table1 ...
      (comp.databases.oracle.server)
    • Common prob with mysql LOAD DATA LOCAL INFILE ...
      ... i have most recent php & mysql versions running on a linuxmachine ... i want to use LOAD DATA LOCAL INFILE and pass it from php to mysql. ...
      (comp.lang.php)