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