Hello.
> my mysql version is 4.2.2 Are you sure that you have this version? I strongly recommend you to use the latest release (4.1.15 now). > The used command is not allowed with this MySQL version Have a look here: http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html 'Yemi Obembe wrote: > 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. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]