[lug-nuts] MySQL Load Data problem

From: Webb Sprague (wsprague100@yahoo.com)
Date: Fri Dec 31 1999 - 12:43:37 PST


Hi All.
I am working on a tiny database thing in MySQL. I
want to load a file into a table, wher the file is on
my home directory. However, when I try to execute
"load data infile '/home/webb/tmp/webbbooks' into
table book;" it returns "Can't get stat of
'/home/webb/tmp/webbbooks' (Errcode: 2)"
Any thoughts? Maybe it's permission problems? Maybe
the file needs to be in the same directory as the
databases ("/var/lib/mysql" I think)?
Thanks again
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com
****************************************************************************
* To UNSUBSCRIBE from the list, send a message with "unsubscribe lug-nuts"
* in the message body to majordomo@saclug.org. Please direct other
* questions, comments, or problems to lug-nuts-owner@saclug.org.



This archive was generated by hypermail 2b29 : Fri Feb 25 2000 - 14:29:09 PST