Please excuse a relative amateur worrying a problem. I got a nice reply from Victoria Reznichenko yesterday on a difficulty loading data from a text file. She said 4.0.12 had a bug and, I as understood her answer, I should therefore enable "load local infile".
Instead I uninstalled 4.0.12 and loaded 4.0.14 after long download assuming that would deal with the bug. It set up nicely. I used MySQLFront - a GUI - to try and import data. It produced this: LOAD DATA LOCAL INFILE 'C:/My Documents/EPSRsearchbase/1173-1195edited.txt' INTO TABLE epsr_content.headlines FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (epsr_id,headline,paper_date,PaperName_ID,author_id) and once more imediately got this: Error: 1148 - The used command is not allowed with this MySQL version --- which was the problem in the first place. [I get the same result using PHPMyAdmin 2.5 via a local Apache server running on my Windows ME PC.] I assume if I use a command line I will also get the same. Perhaps I misunderstood and whatever version I have I still need to enable Load local infile? I do not know how to do that. Can someone explain what is probably a very simple matter or is something still not happening correctly? Or should I revert to version 3 for my fairly simple training purposes? I am puzzled because previously this did work. Thank you. Regards Adrian Greeman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
