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