thanx 4 your reply:
this is the error message that i got when i tried using the full pathname. mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) mysql> i've tried using another user account (of course i've set all the permission using GRANT statement), but it didn't work either. this is my current directory looks like: [ihot@localhost ihot]$ ll total 72 -rwxr-xr-x 1 ihot root 5882 Jun 12 12:18 bestrock.playlist -rw-rw-r-- 1 ihot ihot 32 Aug 12 16:18 imptest.txt -rw-r--r-- 1 root root 32 Aug 12 17:01 imptest.txt1 -rw-rw-r-- 1 ihot ihot 31 Aug 12 16:06 member.txt -rw-rw-r-- 1 ihot ihot 40 Aug 12 16:01 student.txt -rw-r--r-- 1 root root 40 Aug 12 16:53 student.txt1 anyway, thanx 4 your help... i'll try to figure it out, how this thing happens. (time will tell) 8-) thank u.... >From: Paul DuBois <[EMAIL PROTECTED]> > === cut ==== > >When you don't use LOCAL, the server is the one reading the file, not >the client. The server has no idea what your current directory is. >Try using the full pathname. (Note that this will still fail unless >the file is readable to the user that the server runs as.) > _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- 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
