When I try to load a text file with the table content using PHPMyAdmin, I get this error:
LOAD DATA LOCAL INFILE 'D:\Programs\PHP\uploadtemp\php103.tmp' REPLACE INTO TABLE archive FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
MySQL said: File 'd:programsphpuploadtempphp103.tmp' not found (Errcode: 2)
The content of the text file:
1;This is a test heading;Normally, here should be an article;1\n
2;This is the second test heading;Here will be an article as well;1\n
Nevermind, I used tab-delimited text files and it worked perfectly (thanks Adam!).