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.