From: 'Yemi Obembe (fickledreamsyahoo.com)
Date: Thu Oct 20 2005 - 06:13:39 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]