on 3/8/01 12:13 AM, Jennifer at [EMAIL PROTECTED] wrote:
> I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
> can't create the file and Errcode 2. I've tried searching the archives,
> but for some reason it keeps crashing my browser.
On my system (Mac OS X) errcode 2 in this context means a directory
somewhere in your path does not exist. I'm not sure how much the numerical
errors vary from unix to unix...
Remember that INTO OUTFILE expects a path to a file on the _server_, not the
client. Also, mysqld must have permission to create the file. On my setup, I
have a world-writable directory in my home directory on the server called
"Drop Box" (this is standard on OS X) which I write to.
Hope this helps,
Geoff
---------------------------------------------------------------------
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