Unix Technical Forum

Spfile in Mysql......

This is a discussion on Spfile in Mysql...... within the MySQL General forum forums, part of the MySQL category; --> Hello, The dynamic changes made on mysql server instance gets vanished once the instance goes down...!! Is there any ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:02 AM
Shanmugam, Dhandapani
 
Posts: n/a
Default Spfile in Mysql......

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....

Thanks & Regards ,
Dhandapani S


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 07:02 AM
Baron Schwartz
 
Posts: n/a
Default Re: Spfile in Mysql......

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:26 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com