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