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]

Reply via email to