php mysql LOAD INTO INFILE not working

Asked Nov 23 '13 at 05:57

Active Nov 23 '13 at 06:04

Viewed 89 times

i my php i have

$import = mysql_query("LOAD DATA LOCAL INFILE<br>
'/directory/unzip/CARACTERISTIQUES.TXT'
REPLACE INTO TABLE CARACTERISTIQUES
FIELDS TERMINATED BY ','
ENCLOSED BY '\"' 
LINES TERMINATED BY '\\r\\n'");


if (!$import) {echo "<br/>error! insert-db failed : ". mysql_error();}
else {echo "<br/>yeah!";}

i read that i need to have

$db_connect = mysql_connect($db_server,$db_userid,$db_pass,false,128);

to open my connection.

in my phpinfo file i get

Directive   Local Value Master Value
mysql.allow_local_infile    On  On

but i keep getting the follwing error :

The used command is not allowed with this MySQL version

any thoughts ?

asked Nov 23 '13 at 05:57

zefrank

Do you really have `
` in your query? – Barmar Nov 23 '13 at 06:00
What version of MySQL are you running? – Barmar Nov 23 '13 at 06:02
did you call `mysql_select_db()` after opening the connection? – Barmar Nov 23 '13 at 06:04
version running = 5.5.34 – zefrank Nov 23 '13 at 06:06
@BillKarwin The answers there are for using the command line tool. They don't show how to do it from an API. – Barmar Nov 23 '13 at 06:06
the
is just in the output of the error, yes, i have other queries that run fine just before in the code. – zefrank Nov 23 '13 at 06:07
Why do you have `
` at the end of the `$import = mysql_query("LOAD DATA LOCAL INFILE
` line? That's not valid SQL. – Barmar Nov 23 '13 at 06:17

php mysql LOAD INTO INFILE not working

0 Answers0