MySQL Bugs: #24545: MySql Administrator comments out settings in my.ini

Bug #24545	MySql Administrator comments out settings in my.ini
Submitted:	23 Nov 2006 14:28	Modified:	31 Dec 2006 1:04
Reporter:	Yahoo Serious (Silver Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.5 rc	OS:	Windows (Windows 2000 SP4)
Assigned to:		CPU Architecture:	Any

Description:
Duplicate of Bug #23885, related to Bug #24019.

I had to start a new duplicate bug, since only registered developers and the original submitters are allowed to attach files to the bug, and I can't add the files textually, as the contents are too long to post.

When I make a change to the startup variables in MySql Administrator, all [mysqld] section settings are commented out and the changed setting is added at the end of the my.ini file.

NB: The bug appeared with MySql Server 4.1.21, I did not see it with 5.0.27(!)

How to repeat:
I can repeat it, with:
 - Windows SP2000 SP4
 - MySql Server 4.1.21
 - MySql Administrator 1.2.5 rc

I will post <my.ini.right>, put this as <my.ini> in the
MySql-install-directory.
 - start MySql Server 
 - start MySql Administrator
 - Go to "Startup variables" > "Performance"
 - Change "Query cache" e.g. to "50k"
 - exit MySql Administrator
 - check that <my.ini> now looks like posted <my.ini.wrong> 
   with many (but not all) commented parameters
(- try to start MySql Administrator and notice Bug #24019)

Suggested fix:
No idea

correct input my.ini

Attachment: my.ini.right (application/octet-stream, text), 9.06 KiB.

wrong output my.ini

Attachment: my.ini.wrong (application/octet-stream, text), 9.16 KiB.

Thank you for the bug report. I was unable to repeat:

C:\>cat "c:\Arquivos de programas\MySQL\MySQL Server 5.0\my.ini" | findstr /I query_cache
query_cache_size=50k

Did you compare your old file to your new file?

I now notice I copied the existing description:
 "all [mysqld] section settings are commented out"
But I also wrote:
 "with many (but not all) commented parameters"

It comments out "query_cache_size" 3 times and adds a new (uncommented) one.
Furthermore it comments all other lines, except the (manually added) "default-collation=latin1_bin"

Fixed in (duplicate) Bug #24824.