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 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 added file /home/bpc/.my.cnf
> with the parameter tmpdir=/home/bpc but that did not
> fix the problem.
> ---
> Brian Cassidy [EMAIL PROTECTED] http://people.unb.ca/~bpc
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
