load data infile

[kehers]

i'm trying to use the load data infile addin of mysql to load some text values to a table. unfortunaltety my verssion of mysql doesnt support it. As with all things, is there any other way to do this?

 

[KarveR]

you may require the keyword local.

load data local infile '/path/to/file' into .....

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[kehers]

I included that as well :-(

 

[KarveR]

What version of mysql are you running ?,

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[kehers]

here exactly is how d statement went....

<?php
mysql_connect("localhost", $username, $password);
mysql_select_db("ng");
$sql = "load data local infile 'movies.txt' into table dir fields terminated by '|'";
if($res = mysql_query($sql))
echo "correct";
else 
echo mysql_error();
?>

the script and movies.txt are in the same directory. the mysql version is 4.0.22

 

[KarveR]

you'll need the absolute path for the infile command to work.

you can use getcwd() for the path.

$sql="load data infile '".getcwd()."/movies.txt' into table dir fields terminated by '|'";


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.