MySQL Forums
Forum List  »  Perl

Re: creating a text file output from a table
Posted by: David Shrewsbury
Date: August 29, 2006 07:39AM

Errcode:2 means "No such file or directory". When you specify a relative pathname for the outfile (i.e., only a partial path), the server looks for that path starting from its data directory. I expect this is not what you want, so specify the full pathname (e.g., /home/kss/lauradata.csv or whatever). You should also be certain that the user that the mysql server runs as has permissions to write to that directory. On Unix systems, I usually use /tmp for this purpose.

-Dave

Options: ReplyQuote


Subject
Written By
Posted
Re: creating a text file output from a table
August 29, 2006 07:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.