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
