I just tried to load edited data from a text file separated by |
characters into a table in a simple data base
I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows
XP - I thought it was all set up right and configured properly
- and earlier was able to populate the table with some initial data. Now
I was trying to add more from a simple text file using the
LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\php3E.tmp' INTO TABLE
`headlines` FIELDS TERMINATED BY '|' ENCLOSED BY '"' ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'
instruction which phpMyAdmin creates.
It refused to do it and returned the error message:
#1148 - The used command is not allowed with this MySQL version
I feel there must be a simple explanation
May I ask if anyone can help???
Regards
Adrian
PS I am only on digest so please be patient if it takes a while for
futher dialogue on this
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
