Load Data Infile Problem!!!!

Nickosssss

Hello there

i am using this php script

else if (isset($_POST['bt4']))
{
$popStud =
"LOAD DATA INFILE stud.txt INTO TABLE student FIELDS TERMINATED BY '|' ESCAPED BY '\' LINES TERMINATED BY '\r\n'";

	$res_pop = $db->query($popStud);						
}

athough the query works fine if used with MySQL, it does not work when the user presses the button. Does anybody know why?

dfr574

You can check the permissions and add the absolute path to stud.txt.

Nickosssss

what do u mean to check the permission?

do i need the absolute path? why does it work to the MySQL then?

ragefu

Because I think by default, mysql will only look in its db directory for 'stud.txt', unless you supply a path otherwise.

Nickosssss

yes the problem is not with MySQL....i have put the query to the folder of the database and when i try to execute the query from the MySQL command prompt window it works fine

But then i have put the query to the PHP script and i try to do the same by clicking a button and nothing happens....isnt it weird?

so the problem is not with the actual query but with PHP ....maybe i need to specify the path there....????

dfr574

yes.

LOAD DATA INFILE 'c:\path\to\directory\stud.txt' INTO TABLE student ....

Also make sure that the user that runs the web server service has permission to read the file.

Nickosssss

oh i see...how do i set this permission?

Nickosssss

this path directs to the PHP directory or to the MySQL directory?

dfr574

The path is to the stud.txt file, where ever you have it on our file system.

Nickosssss

i have tried everything i dont know...whats going on....it pisses me off....the chmod command is only for UNIX right? how do i change mode for windows?

$popStud2 = "LOAD DATA INFILE 'C:/Program Files/MySQL/MySQL Server 4.1/data/test2/stud.txt' INTO TABLE student FIELDS TERMINATED BY '|' ESCAPED BY '\' LINES TERMINATED BY '\r\n'";

this is what i use...