At 6:11 PM -0400 8/13/10, Daniel P. Brown wrote:
On Fri, Aug 13, 2010 at 17:48, tedd <tedd@xxxxxxxxxxxx> wrote:
SELECT * FROM table_reference INTO OUTFILE 'file_name'
It looked to be bit simpler/shorter than my code, so I tried it. But it
reports:
Access denied for user 'me'@'localhost' (using password: YES).
I suspect that the "access being denied" is because MySQL doesn't have
permission to create the output file. The MySQL manual reports: 1) that a
file cannot be present; 2) AND MySQL must have file privileges to create the
file -- but I don't know how to set that up.
No, the 'access denied' message means that either the username or
password is incorrect, or that the given user doesn't have permission
to access the given database on the given host.
Daniel :
I don't think so and here's my reasoning.
You see in the same script, I tested the connection to the database
with a query *before* the OUTFILE statement and it worked! If the
username and/or password had been wrong, then it would have also
failed. Here's the demo:
http://php1.net/c/db-dump/db-2-dir.php
Please note that the string 'BKohl41' noted is the result of a query
to the same database *before* the OUTFILE query.
As far as I can tell, the MySQL statement does not have permission to
create a file and that's the problem as I see it.
I shall test Daevid's "GRANT SELECT, FILE ON mydb.table_reference TO
'me'@'localhost';" statement tomorrow -- it looks promising.
As for the:
"You know you can pass that on the command line right and avoid this pipe
business?"
No, I don't know how to do that.
Cheers,
tedd
--
-------
http://sperling.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
