You need GRANT permission. The syntax is something like: GRANT FILE ON *.* to person@"%";
Keep in mind, FILE is a global permission, so the user will have it across all databases. On Aug 14, 2010 11:27 AM, "tedd" <[email protected]> wrote: > Hi: > > First, I'm a PHP programmer and not a MySQL guru. > > Second, I usually can get MySQL to do anything I want -- however, > this OUTFILE thing has me stumped. > > My mission is to simply backup a database and do it through PHP and > not via a command line -- I don't have access to the server shel -- > this is a hosted account. Please don't tell me how to use the command > line to solve this problem. > > Here's what I've done and it illustrates the problem: > > After establishing a successful connection to the database, I can > execute queries like the following -- > > [1] > > $query = "SELECT * FROM users WHERE id='113' "; > $result = mysql_query($query) or die(report($query,__LINE__ ,__FILE__)); > $row = mysql_fetch_array($result); > $login = $row['login']; > > -- with no problems. > > However, if I try: > > [2] > > $file = '/home/mydomain/public_html/db-dump/tmp/db.txt'; > $query = "SELECT * FROM users INTO OUTFILE '$file' "; > $result = mysql_query($query) or die(report($query,__LINE__ ,__FILE__)); > > Where the 'tmp' directory has permissions set to 0777. > > I receive the following error: > > "Access denied for user 'mydomain_user'@'localhost' (using password: YES)" > > Normally, that type of error would be generated by a > username/password problem. However, the code shown in [1] works while > the code shown in [2] does not work and both segments of code are in > the same script with an established connection. > > My investigation reading through the MySQL manual leads me to: > > http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_file > > It states that I must have FILE permissions to read/write files on > the server host to use OUTFILE. > > So, my question is "How do I set the FILE permissions for a MySQL query?" > > Many thanks for any answer or clarification. > > Cheers, > > tedd > > PS: I asked a similar question to the PHP list, but they didn't > couldn't help me. > -- > ------- > http://sperling.com/ > _______________________________________________ > New York PHP Community MySQL SIG > http://lists.nyphp.org/mailman/listinfo/mysql > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
