Professional Web Applications Themes

LOAD DATA LOCAL INFILE and Perl DBI/DBD - PERL Modules

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

  1. #1

    Default LOAD DATA LOCAL INFILE and Perl DBI/DBD

    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

    Jami Bradley Guest

  2. #2

    Default Re: LOAD DATA LOCAL INFILE and Perl DBI/DBD

    As a workaround, we had to code the module to shell out to mysql and execute each of the (100)
    commands. Obviously this is really slow because each command establishes a connection, executes,
    then closes the connection.

    Does anyone have any suggestions how we can get back to using DBI, this is driving me crazy :-)

    Thanks!

    Jami

    On Wed, 23 Jun 2004 15:43:03 -0600, Jami Bradley <jbradleyisa-og.com> wrote:
    >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
    Jami Bradley Guest

Similar Threads

  1. LOAD DATA INFILE
    By Luca in forum MySQL
    Replies: 4
    Last Post: July 11th, 12:35 PM
  2. Complex LOAD DATA INFILE
    By stefaan.lhermitte@agr.kuleuven.ac.be in forum MySQL
    Replies: 6
    Last Post: May 18th, 06:34 PM
  3. Load Data Infile question
    By bradfordh@gmail.com in forum MySQL
    Replies: 3
    Last Post: March 23rd, 04:53 AM
  4. help : LOAD DATA LOCAL INFILE
    By Dave in forum PHP Development
    Replies: 3
    Last Post: October 5th, 12:22 AM
  5. mysql load data infile error from inside a perl program
    By Balldrew J. Bag in forum PERL Miscellaneous
    Replies: 1
    Last Post: July 26th, 01:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139