At 12:46 PM -0300 8/14/10, Fernando Gabrieli wrote:
Hi tedd, if you have FTP access you could create the file and chmod
it to be able to write from the mysql query
That sounds good, but I've tried it.
There are two things wrong here.
One is that while *I* (my script) can establish FTP access to the
account and create/write a file, that does not also mean that MySQL
(even under the direction of my script) can create a file. Apparently
MySQL requires additional permissions for the user to be able to do
that.
Two, MySQL requires that the file to be written to can not exist. In
other words, the OUTPUT file must be created by the OUTPUT query and
the file cannot exist beforehand. This is so that MySQL will not
overwrite existing files.
Many thanks for your time.
Cheers,
tedd
--
-------
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
