Bug #72410 write to configuration file using SQL
Submitted: 21 Apr 2014 8:14 Modified: 24 Apr 2014 21:16
Reporter: Jassim Rahma Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[21 Apr 2014 8:14] Jassim Rahma
Currently, the SET VARIABLES is used to update in memory only. Permanent changes should be made in the configuration file only.

I suggest you provide an option to update the coniguration file using the SET VARIABLES similar to the SCOPE option in Oracle database so may somethine like this:

SET VARIABLE param_name = param_value PERMANENT

How to repeat:
it's a suggestion
[24 Apr 2014 16:53] Hartmut Holzgraefe
Amongst other issues with this idea,
which file would you write to if the 
!include / !includedir features are
used in my.cnf?
[24 Apr 2014 21:16] Jassim Rahma
what I meant is avoid to touch the physical files and just do everything using the SQL just like Oracle Database so instead of changing a variable or parameter in my.cnf I should be able to SET it and make the SCOPE=FILE or BOTH or whatever so it will be permanent without having to edit a file.