i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
<?php
mysql_connect("localhost", "$user", "$pass");
mysql_select_db("ng");
$sql = "load data local infile 'movies.txt' into table dir fields terminated by
'|'";
if($res = mysql_query($sql))
echo "loaded";
else
echo mysql_error();
?>
the script and the txt file movies.txt reside on the same directory. runnign
the page, i get the error: The used command is not allowed with this MySQL
version
my mysql version is 4.2.2
what could be wrong? by the way, i'v tried changing the movies file path to a
full path but still doesnt change things.
---------------------------------
A passion till tomorrow,
Opeyemi Obembe | ng.clawz.com
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
