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