Re: creating a text file output from a table
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
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.