Announcement

Collapse
No announcement yet.

Load data local infile error importing to mysql

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Load data local infile error importing to mysql

    I am having error while using load data local infile on button..
    --here's the code
    sc_exec_sql("load data local infile '/PATH/IMPORT/FILE' into table TABLETOIMPORT fields terminated by '\t' lines terminated by '\n'")

    this script returns:

    Error while accessing the database:
    The used command is not allowed with this MySQL version


    but it works fine when i execute this same script on mysql on server(Ubuntu server)

    load data local infile '/PATH/IMPORT/FILE' into table TABLETOIMPORT fields terminated by '\t' lines terminated by '\n'

    How to solve this problem??

    Thanks!

  • #2
    Originally posted by rendonjerome14 View Post

    The used command is not allowed with this MySQL version
    Your have local another version of mysql than on the ubuntu server?
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

    Comment


    • #3
      Originally posted by RHS View Post
      Your have local another version of mysql than on the ubuntu server?
      Hi, I'm using Ubuntu Server . here's the info

      Ubuntu Server 13.04
      php 5.4.9-4ubuntu2.2 (cli)
      zend engine v2.4.0
      mysql version 14.14 Distrib 5.5.31

      Comment

      Working...
      X