This also does not enable me to upload a data file. My resulting SQL
statement reads:
LOAD DATA LOCAL '/tmp/phpgPhl51' INTO TABLE test FIELDS TERMINATED BY ','
ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
I have also tried:
LOAD DATA LOCAL INFILE '/tmp/phpgPhl51' INTO TABLE test FIE
I developed a PHP application where users can update a mySQL table using
LOAD DATA. Recently I installed this application on another web server where
the File Permissions have been set such that this method of uploading data
is no longer valid. Since phpMyAdmin is not an option I am trying to find