Re: [PHP] It's Friday (a MySQL Question)

Tedd I don't know if this will resolve your issue or not, but have you
looked into using mysqldump?

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

That's what I use for my backups.


Chris.

On Fri, Aug 13, 2010 at 6:47 PM, tedd <[email protected]> wrote:

> At 6:11 PM -0400 8/13/10, Daniel P. Brown wrote:
>
>> On Fri, Aug 13, 2010 at 17:48, tedd <[email protected]> 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
>
>