File Permissions Windows

[Nickosssss]

Hello there....i am using the LOAD DATA INFILE to load from a txt file. Although it works fine with the MySQL command it does NOT work with Script...does anybody know why?

[kakki]

maybe your apache is running in a different user-space than your personal account

in linux, i'd suggest that u chmod all "load data infile" files ....
in the windows-world, i'd guess, that u change the properties of the dir and file, so that
everybody can read the file

[Drakla]

Can we see some of your code, and are you escaping the file name before you put it into the script query? That's a right popular mistake to make.

[Nickosssss]

$grantPriv = "GRANT ALL ON test2.* TO 'root'@'localhost' IDENTIFIED BY '323232'";
$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'";

	$popStaff = "LOAD DATA INFILE 'staff2.txt' INTO TABLE `staff` FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";
	//LOAD DATA INFILE '\test\stud.txt' INTO TABLE `student` FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';
	$res_grt = $db->query($grantPriv);						
	$res_pop = $db->query($popStud2);						
	$res_pop2 = $db->query($popStaff);		
	echo '<p class = status> You have successfully populated the database. </p>';				
}
else if (isset($_POST['bt5']))
{
	echo '<p class = status> You have successfully extracted information about students and superivosrs. <br> (students.txt and supervisors.txt) </p>';				
	$stud_txt = "SELECT * INTO OUTFILE '/webs/test/students.text' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' FROM student";
	$staff_txt = "SELECT * INTO OUTFILE 'supervisors.text' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' FROM staff";
	$res_stud = $db->query($stud_txt);						
	$res_staff = $db->query($staff_txt);						
}

here it is....the outfile does not work either....i guess its about the file properties because the MySQL executes the queries and the result is the desired

thank you guys

[kakki]

when i did your "grant" statement( on the "test"-table ) it resulted in sth. like
"USAGE"

after that, i checked the privileges on that account and there was no "file"-priv.

maybe, you can change that on "whateverDB.*" to grant a "global" priv.

[Nickosssss]

mmmmm what do u mean to change the whatever db? change the database? do u know how to change the file permission for the windowns?

[kakki]

GRANT FILE ON test2.* TO 'root'@'localhost' IDENTIFIED BY '323232'