Found the solution: I had to change row
$fpName = tempnam($dir, "tableData"); to $fpName = tempnam("", "tableData"); So file will be created to a temporary directory. Niklas P.S. :) -----Original Message----- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: 6. marraskuuta 2001 14:56 To: Php-General; Php-DB Subject: [PHP] mySQL LOAD DATA INFILE I have this code: <? $dir = getcwd(); $fpName = tempnam($dir, "tableData"); $fp = fopen($fpName, "w"); fputs($fp, $strData); fclose($fp); $QueryInsert = " LOAD DATA INFILE '$fpName' INTO TABLE feStatics FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' "; mysql_query($QueryInsert); print mysql_error(); unlink($fpName); ?> It returns "Can't get stat of '/www/publico2/tableData0TMRRy' (Errcode: 13)". I'd put this file into mySQL's database dir, but I have no access there. Any ideas how to do this? Inserting file row by row would take like eternity, so that is not a good idea. Niklas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]