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.