Implement the ability to delete/modify files that are created by using SELECT INTO OUTFILE

Bug #1668045 reported by Aleksey Filippov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Wishlist
Unassigned

Bug Description

At the moment, for security reasons in MySQL implemented the ability to create files only through SELECT INTO OUTFILE.
The ability to overwrite or delete files is missing. In the case of a large number of files you create, implementation of removal procedure possible only in non MySQL way.
It is proposed to implement the safe removal option for OUTFILEs. For example:
1. Allow only delete the files that exist in directories tmpdir, thus isolating the OS from the database.
2. Implement registration procedure for all files created using the OUTFILE, respectively delete and change only files passed the registration procedure.
3. Create a single global parameter specifies where OUTILEs will be created, and allows you to manipulate files only within this parameter.
4. Create a global parameter that will indicate the allowable operations for OUTFILEs (create, change, delete)
In MySQL really lacking quality file manipulation procedures.

Changed in percona-server:
importance: Undecided → Wishlist
status: New → Triaged
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2493

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.