Hi,

John Kopanas wrote:
I am doing the following:

echo 'SELECT * FROM jobs WHERE id = 1 INTO OUTFILE
"/Users/jkopanas/Sites/test_this_out.csv";' | mysql -uroot
backlog_development

And I get the following error:
ERROR 1 (HY000) at line 1: Can't create/write to file
'/Users/jkopanas/Sites/test_this_out.csv' (Errcode: 13)

I found this on mysql:
http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

I checked to see if root had File_priv and he/she does.  I am
developing this on Mac OS X but I am deploying on a linux box.

Does /Users/jkopanas/Sites/ exist? Does the user MySQL runs as have permission to write to it?

Baron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to