How do I get LOAD DATA INFILE to work on my server? #10732
Labels
answered
For when a question was asked and we referred to forum or answered it.
Bug
For errors / faults / flaws / inconsistencies etc.
c: Performance
For when we could improve the performance / speed of Matomo.
Milestone
http://piwik.org/faq/troubleshooting/#faq_194 describes what to do if the system report warns that LOAD DATA INFILE is not usable.
In fact, LOAD DATA INFILE does work on our infrastructure but it seems piwik is not passing the appropiate client flags to mysql_connect, when connecting to the mysql server.
see http://php.net/manual/de/mysql.constants.php#mysql.client-flags and http://dev.mysql.com/doc/refman/5.7/en/load-data-local.html#c5457
Passing the correct client flags during connection would allow the usage of LOAD DATA LOCAL INFILE.
Thanks.
The text was updated successfully, but these errors were encountered: