I’m trying to load a csv file into MySQL, using LOAD DATA LOCAL INFILE, which is 1000x faster than processing it with php.
It works on local, but in 000webhost,mysql cannot find the file. I have tested puting file in /tmp directory, but it does not work either:
LOAD DATA LOCAL INFILE ‘/tmp/data.csv’ INTO TABLE data;
SQLSTATE[HY000]: General error: 2 File ‘/tmp/data.csv’ not found (Errcode: 2)
How can I achieve this?