--- Mike Machado <mike@innercite.com> wrote:
> 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
>
****************************************************************************
Hi Mike and everyone else. I fixed it, here's how.
First I tried making my 0777 and keeping it in my home
directory, but that didn't work. So I moved it to
/var/lib/mysql/bookswap (where the database lives),
and it works fine. Maybe one needs to run mysqld or
mysql with an option to make the default storage
location something else.
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