Try putting the file into the MySQL directory, or one the that mysql has permissions on. I bet 2 cents it will work.
> -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 6:52 PM > To: LR P; [EMAIL PROTECTED] > Subject: Re: load data infile --- problem > > > 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 > --------------------------------------------------------------------- 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
