Re: Re: permissions for writing file

James, Who are you logging in as and do you have write privileges in that directory? Who owns it: user and group? (Don't have to answer, that's just what you have to know. Alternately, is there a "mysql" user in /etc/passwd? What group? The answer probably lies in there somewhere. Is there any possibility you can use a Secure Shell (SSH) on that machine? It's much safer than telnet. If you're reaching it from a windows box you can use putty.exe or terraterm ssh for access. Both are secure clients. Regards - Miles Thompson At 09:42 AM 1/14/2002 -0500, James Kupernik wrote:

My problem is that I'm trying to run the query via a telnet sessions before I code through PHP. Is there a solution that anyone knows for this? "James Kupernik" <kupernik@bcn.net> wrote in message news:20020114134312.77433.qmail@pb1.pair.com... I'm trying to use PHP and MySQL to query a table and write the contents to a new file. When run the command to outfile it tells me I don't have permissions. This is on a Unix machine. mysql> select * into outfile "/home/u1/funfun/www.somewebsite.com/catalogreq/ catalog.txt" mysql> fields terminated by ',' optionally enclosed by '"' mysql> fields terminated by ',' optionally enclosed by '"' mysql> fields terminated by ',' optionally enclosed by '"' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net