LOAD DATA LOCAL INFILE - Workaround for local-infile=0 ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Andreas Emmert

    #1

    LOAD DATA LOCAL INFILE - Workaround for local-infile=0 ?

    Dear NG,

    I'm using a PHP script for updating my database which relies on the "LOAD
    DATA LOCAL INFILE" command. As my provider recently updated the
    MySQL-database, he changed the "local-infile" setting to zero, i.e. my
    update-script doesn't work anymore (=> "The used command is not allowed with
    this MySQL version").

    Is there a work-around to fix this problem? I though about the mysql_options
    command, but to frankly speaking, I have no clue how to use it and couldn't
    figure out how to properly use it even after reading the manual ... anyone
    who could help?

    Thanks for your help!

    --
    Andreas


Working...