List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 14 1999 4:37pm
Subject:Re: Import of data from text file
View as plain text  
At 8:10 PM +0530 10/13/99, whizkids wrote:
>Dear Sir,
>I get message when I try to import a text file into my SQL database :
>    load data infile "data.prn" into table books
>I get message "access denied for user wipl@stripped   [Password : Yes]

You don't have the file privilege on the server host.

If the file is really on the client, use LOAD DATA LOCAL INFILE instead.

Paul DuBois, paul@stripped
Import of data from text filewhizkids14 Jul
  • Re: Import of data from text filePaul DuBois14 Jul
  • Import of data from text fileMichael Widenius3 Aug