The SERVER needs to be able to read the file, and I doubt very much that mysql has read permissions here.
Jim Bahr wrote: >Hello >I am trying to use the LOAD command and not having much success. My host >company is using version mysql 3.23.51. I am sshing into server, >starting mysql and getting a mysql prompt. I have a database called >login, and have made an empty table called logintest. I want to load it >with data from a text file (downacct.txt). The text file is in a dir. >called websites (the higest permission level I have on this shared >server) > >I use the following commands > >USE login; > >LOAD DATA INFILE '/home/cbslink/websites/downacct.txt' INTO TABLE >login.logintest; > >And get the following; >ERROR 1105: File '/home/cbslink/websites/downacct.txt' not found >(Errcode: 13) > >Any ideas? Is there another way I can move this large amount of data >into a table? > >Thanks ahead of time > >Jim > > >--------------------------------------------------------------------- >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
