Jim, Tuesday, October 01, 2002, 4:01:18 PM, you wrote: JB> I am trying to use the LOAD command and not having much success. My host JB> company is using version mysql 3.23.51. I am sshing into server, JB> starting mysql and getting a mysql prompt. I have a database called JB> login, and have made an empty table called logintest. I want to load it JB> with data from a text file (downacct.txt). The text file is in a dir. JB> called websites (the higest permission level I have on this shared JB> server)
JB> I use the following commands JB> USE login; JB> LOAD DATA INFILE '/home/cbslink/websites/downacct.txt' INTO TABLE JB> login.logintest; JB> And get the following; JB> ERROR 1105: File '/home/cbslink/websites/downacct.txt' not found JB> (Errcode: 13) JB> Any ideas? Is there another way I can move this large amount of data JB> into a table? $ perror 13 Error code 13: Permission denied MySQL doesn't have permissions on that file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
