Dear Jake and MySQL listers, RE:>> I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that???
I can't say for certian, though I would imagine that the mysqld actually does the processing on this type of a table load, i.e. it controls access to the mysql engine, not the user. This is why, whenever I want to do an import, I execute thusly: # mysql -u mysql -p < script_to_load_file Again, this may not be 100% requisite, but I'm into error prevention and this pretty much ensure that I won't bump into permissions issues. I don't lke setting a fill to 777 but prefer 755. Others can help with greater accuracy but this may be of some help for the future. Andrew Lietzow The ACL Group, Inc. On Friday 24 May 2002 08:44 am, Menard, Inc. Information Systems wrote: > I figured it out but I'm a bit confused as to why it happened. > I'm running the load as user1. The file resides at > /home/user1/data/filename Permissions: > filename 666 > data 777 > user1 700 > > I had to change permissions on user1 to 777 in order for it to work. If I'm > logged in as that user, why would I have to do that??? > > Thanks > Jake > > -----Original Message----- > From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 8:26 AM > To: Jay Blanchard; [EMAIL PROTECTED] > Subject: RE: Newbie--Easy data loading question > > > yes. I tried all of these methods: > 1) "//dir1//dir2//file" > 2) "/dir1/dir2/file" > running load from file dir using: > "./file" > ".//file" > > I also check the file permissions and it is all read/write. > I can't remember if I tried to run it using mysqls root yet...that would be > the next step, but I prefer not to go there. > > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 8:22 AM > To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED] > Subject: RE: Newbie--Easy data loading question > > > did you supply the /full/path/to/the/file/ ? > > -----Original Message----- > From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 8:15 AM > To: [EMAIL PROTECTED] > Subject: Newbie--Easy data loading question > > > Hello > > Forgive me for being a little naive but..... > > I am trying to load a table with a text file using the load data infile > command in mysql. I can do it if I place the > text file in the db directory, but I want it to reside in a different dir. > I am getting the error 13: Can't get stat on.... > What am I doing wrong?? > > Thank you very much in advance for your help! > > Jake > > > --------------------------------------------------------------------- > 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 -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c --------------------------------------------------------------------- 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
