Thanks for the answer - but I am already the root user and have
phpMyAdmin using the root also (because this is just a single computer
for testing work and there are not any bit security issues).
----- Original Message -----
From: "Remi Mikalsen" <[EMAIL PROTECTED]>
To: "adrian Greeman" <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 1:47 AM
Subject: Re: ERROR ON INSERT DATA FROM FILE
Hello Adrian.
I'm not very experienced with MySQL, but I believe that you need special
privileges to
load data from a file.
Normally, other than the root user will not have this kind of privilege.
Without it you will
probably have to ask for someone with do it for you, or give you
permissions to do it. If
you have access to the root account, then try it from there!
Remi Mikalsen
On 21 Apr 2004 at 0:17, adrian Greeman wrote:
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]
Abraço,
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL: http://www.iMikalsen.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
