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 <paul@stripped>
>>
>=== 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 <mysql-thread117017@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
