Last Updated: February 25, 2016
·
469
· thinkinglemur

Load Data Infile Permissions Quickfix

Attempting to use the sql command LOAD DATA INFILE from php script when the script (client) is on a different machine to the mysql server and the user does not have full permissions use the: LOAD DATA LOCAL INFILE. This will allow the file to be successfully imported into the database.