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.
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