Re: Redirecting Outfile

2001-04-15 Thread Tonu Samuel
On 14 Apr 2001 16:55:51 -0300, Brian Cassidy wrote: > Redirecting file output (for user bpc) with a command such as > select * into outfile 'home/bpc/test.txt' from table > gives the error ERROR 1: Can't create/write to file > "/home/bpc/test.txt" (Errcode: 13). The documentation > recommends sett

Re: Redirecting Outfile

2001-04-14 Thread Colin Faber
since the outfile is being written as the user that owns the mysqld process you'll need to make sure that, that user has write access to the location specified. Brian Cassidy wrote: > > Redirecting file output (for user bpc) with a command such as > select * into outfile 'home/bpc/test.txt' from

Redirecting Outfile

2001-04-14 Thread Brian Cassidy
Redirecting file output (for user bpc) with a command such as select * into outfile 'home/bpc/test.txt' from table gives the error ERROR 1: Can't create/write to file "/home/bpc/test.txt" (Errcode: 13). The documentation recommends setting parameter tmpdir. I have RedHat 7 with MySQL 3.23 and so I