List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 13 2002 10:51pm
Subject:Re: load data infile --- problem
View as plain text  
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

Thread
load data infile --- problemLR P13 Aug
  • Re: load data infile --- problemPaul DuBois13 Aug
Re: load data infile --- problemLR P14 Aug
  • Re: load data infile --- problemPaul DuBois14 Aug
    • RE: load data infile --- problemAron Pilhofer14 Aug
      • MysQL + OOoSabdy Serrano14 Aug
      • MysQL + OOoSabdy Serrano14 Aug