Hi Roger, You might just need to set File_priv='Y' in the "user" table in the "mysql" database for the user that you logged into MySQL as.
Don't forget to do a "flush privileges;" after you make the change so that it takes affect. -Joe > -----Original Message----- > From: Greenlaw, Roger [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 16, 2001 2:49 PM > To: '[EMAIL PROTECTED]' > Subject: problems loading a datafile into a database table > > > I have a database defined, and a data file that needs to be > imported into > the table. > > I'm using Red Hat Linux 7.0 as my operating system, and mysql > server is > loaded and running on linux. > > When I type >LOAD DATA INFILE '/home/usrename/datafile.ext' ; > I receive the > following error: > > Error 13: Can't get stat of '/home/usrename/datafile.ext' > (Errcode: 13) > > perror 13 reports Error code 13: Permission denied > > I tried changing my file using chmod 777 datafile.ext and > confirmed that I > am the file's owner. Can anyone help me? > > Thanks, > > Roger Greenlaw, Systems Analyst > Sebasticook Valley Hospital > 99 Grove Street > Pittsfield ME 04967 > (207) 487-5141 Ext. 213 > > > --------------------------------------------------------------------- > 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
