Hi there!
I'd like to import data from a csv file into a mysql database.
To do so I run a sql like "LOAD DATA LOCAL INFILE 'xyz.csv' INTO TABLE `abc`"
but then getting the error "LOAD DATA LOCAL INFILE is forbidden, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory or PDO::MYSQL_ATTR_LOCAL_INFILE|PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY".
Before working with CI I created the database connections with
$attributes = [PDO::MYSQL_ATTR_LOCAL_INFILE => true];
$connection = new PDO('mysql:host=' . $host, $username, $password, $attributes);
but I cannot find a way to do something like that in CI. Can someone give me a clue how to set this option during setting the connection?