Settings >> System Check >> Database abilities

If mysld server is set in /etc/my.cnf file
local-infile=0

You may find a similar error at
Settings >> System Check >> Database abilities

Error:
Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can’t get stat of ‘/home/piwik/tmp/assets/mnet_option-0fc075218ef7cdb0edce55dab29b35fa.csv’ (Errcode: 13),
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]

My question is:
Seems LOAD DATA INFILE only write/read files in /var/lib/mysql/database folder.
Files located at /home/piwik/tmp/assets/ are not read when “local-infile=0” is set in /etc/my.cnf file

Is there any solution to have LOAD DATA INFILE and keep “local-infile=0” set?

If mysld server is set in /etc/my.cnf file
local-infile=1

No error, LOAD DATA INFILE works perfectly
However, local-infile=1 opens vulnaberilities in the machine.

Having exactly the same error, even so local-file is set to ON for me …

Here’s another post on this forum talking about that, where I posted some more information: 301 Moved Permanently

see this FAQ for more info Troubleshooting - Analytics Platform - Matomo load data in file piwik