Re: What is Errcode 2?
Hi, The perror command gives MySQL error messages. [jenik@zarq jenik]$ perror 2 Error code 2: No such file or directory I'd guess you should specify the full path to the output file, and make sure the location is world-writable. /tmp should work on Unix systems. Jan Jennifer 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. Jennifer - 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
What is Errcode 2?
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. Jennifer ~ Looking for books, software, movies, music... http://www.chapters.ca/Default.asp?AFFID=108464 ~ Quality Children's Products - http://Store.MomsAtHome.ca/ ~ Your own domain name for as little as $13 US http://www.mahDesigns.com/domains/ ~ - 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
Re: What is Errcode 2?
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
