List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 13 2001 6:00pm
Subject:Re: LOAD command failed if the Local infile is not \bin
View as plain text  
On Thu, Dec 13, 2001 at 12:34:59PM -0500, hamzatk@stripped wrote:
> Hi,
> 
> I just discovered that I have to move the data text file I want to store in
> my table into bin directory of   mysql  directory (c:\mysql\bin\) before
> the LOAD DATA  local infile "text.txt" INTO TABLE tabname can work.

No just specify the full pathname to the file.  If it's in D:\tmp\text.txt,
use:

LOAD DATA LOCAL INFILE "D:\\tmp\\text.txt" INTO TABLE tabname;

Or:

LOAD DATA LOCAL INFILE "D:/tmp/text.txt" INTO TABLE tabname;

> 
> The problem here is that how do I then transfer this kind of file from my
> local computer if at all i am able to connect to mysql server at the remote
> machine.
> 
> Regards.
> kamal
Thread
LOAD command failed if the Local infile is not \binhamzatk13 Dec
  • Re: LOAD command failed if the Local infile is not \binPaul DuBois13 Dec