View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:02 AM
Jay Pipes
 
Posts: n/a
Default Re: Spfile in Mysql......

Sujatha S wrote:
> Mysql should bring this as there new feature in there next release!


Unlikely. Dynamic changes are, well, dynamic. Permanent stuff goes in
the my.cnf.

-jay

> Regards,
>
> Sujatha
> On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani <
> dhandapani.shanmugam@eds.com> wrote:
>
>> Hello,

>
>
>> The dynamic changes made on mysql server instance gets vanished once

>
>> the instance goes down...!! Is there any way for mysql to store the

>
>> dynamic changes on my.cnf file automatically ..?(like Oracle) , so on

>
>> next startup mysql automatically pickup the dynamic changes made from

>
>> my.cnf file....

>
> Unfortunately there is not. You should alter your my.cnf file to record the
> changes you make.
>
> --
>
> MySQL General Mailing List
>
> For list archives: *http://lists.mysql.com/mysql*<http://lists.mysql.com/mysql>
>
> To unsubscribe: *
> http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com*<http://lists.mysql.com/mysql?unsub=dhandapani.shanmugam@eds.com>
>


Reply With Quote