At 22:21 +0000 8/13/02, LR P wrote: >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>
% perror 13 Error code 13: Permission denied Looks like the server cannot read your file. What are the permissions on your home directory? > >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 --------------------------------------------------------------------- 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
