I am getting the following error upon attempting the following SQL statement:
$sql = "LOAD DATA LOCAL INFILE '$datafile' INTO TABLE persons " .
" FIELDS TERMINATED BY ',' ESCAPED BY '\\\\' OPTIONALLY ENCLOSED BY '\"' " .
" LINES TERMINATED BY '\\n' " .
' (title, first_name, last_name, ' . .
' address1, address2, address3, city, state, country, zip, main_phone, ' .
' alt_phone, mobile_phone, fax, pager, main_email, alt_email, url' .
' )';
Error:
The used command is not allowed with this MySQL version
I am using MySQL 3.23.58 and the mysql.users table indicates the $dbUser on $dbHost has File_priv of 'Y' indicating he/she can use "LOAD DATA INFILE".
The documentation on the MySQL manual gives no indication that you can't use LOAD DATA INFILE in 3.23.58, furthermore, I as $dbUser at $dbHost have the right to use it, so what's going on?
Thanx
Phil
