Re: Exporting Data To File and Can't Create/Write to File

2007-05-28 Thread John Kopanas
Directory existed but I did not have the right permissions on the directory for the mysql user. Thanks my friend. :-) On 5/28/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: Hi, John Kopanas wrote: > I am doing the following: > > echo 'SELECT * FROM jobs WHERE id = 1 INTO OUTFILE > "/Users/jkopa

Re: Exporting Data To File and Can't Create/Write to File

2007-05-28 Thread Baron Schwartz
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_t

Exporting Data To File and Can't Create/Write to File

2007-05-28 Thread John Kopanas
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)