outfile permission error
| From: | James Kupernik | Date: | Mon, 14 Jan 2002 16:09:39 +0000 |
| Subject: | outfile permission error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15776@lists.php.net to get a copy of this message | ||
I'm trying to create a new file on my server from the data in a table. When
I do the query it returns a permission error. I'm logged into my server
through a telnet sessions and the permissions on the dir allow me to write
to it. Here is the query below.
mysql> select * into outfile "/home/u1/me/www.somesite.com/catalogreq/
catalog.txt"
-> fields terminated by ',' optionally enclosed by '"'
-> lines terminated by "\n"
-> FROM catalogs;
ERROR 1045: Access denied for user: 'me@localhost' (Using password: YES)
Any help you be great!! This really has me and my server admin confused.