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


Reply via email to