On Thu, Dec 13, 2001 at 12:34:59PM -0500, [EMAIL PROTECTED] 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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php