Jump to content

Edit History

Lukenzo

Lukenzo

Hi. I am trying to execute csv import to database with: 

$query = "
LOAD DATA LOCAL INFILE '$filePath' INTO TABLE " . self::TABLE_NAME . "
FIELDS TERMINATED BY ';'  
LINES TERMINATED BY '\r\n'
";

DB::getInstance()->execute($query);

But I am getting "Warning: PDO::query(): LOAD DATA LOCAL INFILE forbidden" .

If I do this with MysqliConnection() it works. How to enable MYSQLI_OPT_LOCAL_INFILE for PDO ?

PS 1.7.6.4

Thank  you in advance

Lukenzo

Lukenzo

Hi. I am trying to execute csv import to database with: 

$query = "
LOAD DATA LOCAL INFILE '$filePath' INTO TABLE " . self::TABLE_NAME . "
FIELDS TERMINATED BY ';'  
LINES TERMINATED BY '\r\n'
";

DB::getInstance()->execute($query);

But I am getting "Warning: PDO::query(): LOAD DATA LOCAL INFILE forbidden" .

If I do this with MysqliConnection() it works. How to enable MYSQLI_OPT_LOCAL_INFILE for PDO ?

PS 1.7.6.4

Thank  you in advance

×
×
  • Create New...