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" <[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
