Webb Sprague wrote:
>
> 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.
I know for the load data outfile, it puts it in the data directory.
Perhaps it does need to be there. Based on that error though, it looks
like its a permissions/file problem. It never hurts to experiment :)
-- Mike Machado mike@innercite.com InnerCite Network Specialist **************************************************************************** * 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