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