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

> -----Original Message----- > From: Ashley Sheridan [mailto:ash@ashleysheridan.co.uk] > Sent: Friday, August 13, 2010 3:00 PM > To: tedd > Cc: php-general@lists.php.net > Subject: Re: [PHP] It's Friday (a MySQL Question) > > On Fri, 2010-08-13 at 17:48 -0400, tedd wrote: > > > Hi gang: > > > > Normally if I want to dump a MySQL database, I read the > database via > > a PHP script (i.e., list tables and fetch rows) and save > the results > > as a text file -- after which I download the file -- it's not a big > > deal. > > > > However while I was doing my daily read of the MySQL Manual, namely: > > > > http://dev.mysql.com/doc/refman/5.0/en/select.html > > > > I came across this statement: > > > > 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. http://dev.mysql.com/doc/refman/5.0/en/grant.html http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html#priv_file GRANT SELECT, FILE ON mydb.table_reference TO 'me'@'localhost'; > I've only ever done something like this via the command line. Having > said that, could you maybe pass a command line string to exec(). > Something like (untested): > > echo 'password' | mysql -u root -p < query You know you can pass that on the command line right and avoid this pipe business? mysql -uroot -ppassword < query Or mysql --user=root --password=password < query > I believe that is the right sort of thing, but I've never > quite done it > all as a single statement like this before, I've always tended to type > in things on a line-by-line basis.