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
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 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