Strange response to MySQL query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi gang:

I'm trying to dump a BLOB into a file for subsequent processing.

To do this I'm using the query statements:

$dbQuery = "SELECT  image ";
$dbQuery .= "FROM flowers ";
$dbQuery .= "WHERE image_Id=$pic_id ";
$dbQuery .= "INTO DUMPFILE  '/tmp/test.jpg' ";

But, it generates an "Access denied.." error.

However, if I comment-out the last line, namely "INTO DUMPFILE" statement, then the code accesses the dB (i.e., no access problems).

In thinking it might be permission related, I set permissions for the tmp folder and file to 777, but that didn't help.

Any ideas? I've busted my head on this for several hours now.

Thanks for any help.

tedd

--
--------------------------------------------------------------------------------
http://sperling.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux