Bug #3801 Just a proposal
Submitted: 17 May 2004 17:28 Modified: 5 Dec 2005 12:16
Reporter: Alexander Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:doesn't matter
Assigned to: CPU Architecture:Any

[17 May 2004 17:28] Alexander 
Description:
Cite from the MySQL user manual:
"The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this form of SELECT. The file cannot already exist, which among other things prevents files such as `/etc/passwd' and database tables from being destroyed."

Well... Why not allow a user to overwrite the same file again if it's being placed in some safe folder, which is destroyed after the user is disconnected from the server?

How to repeat:
Nothing to repeat
[5 Dec 2005 12:16] Valeriy Kravchuk 
Than you for a feature request. As for your question:

"Why not allow a user to overwrite the same file again if it's being
placed in some safe folder, which is destroyed after the user is disconnected
from the server?"

How can server check, that folder is safe, really? With symbolic links etc? A lot of misuse, improper use and sequrity problems will be provoked by this feature. So, I do not think that this feature will be implemented.