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