Hi Eve, That error is because the LOCAL part of LOAD DATA is disabled. See here: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
Since your file is probably on the same system as the MySQL server, it should work if you remove the LOCAL word. Hope that helps. Matt ----- Original Message ----- From: "Eve Atley" Sent: Friday, February 20, 2004 12:58 PM Subject: Transferring comma-delimited list imto mysql table > > I have a large email database that has been translated into a CSV, simply > like this: > [EMAIL PROTECTED];[EMAIL PROTECTED]; (etc.) > > I need to get this into SOME format. I have tried Access, which said it was > too large - so I am trying my mysql. I created a table with fields ID, and > email. I just want to put each email into the email field. I get this error: > > LOAD DATA LOCAL INFILE 'C:\\PHP\\uploadtemp\\php7.tmp' REPLACE INTO TABLE > `email` > FIELDS TERMINATED BY ';' > > MySQL said: > > > #1148 - The used command is not allowed with this MySQL version > > Can anyone help me? Excel choked, Access choked. My intent is to pull all > these from MySQL and into Outlook. If MySQL isn't the app to use, perhaps > another solution can be recommended. > > Thanks so much, > Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
