my.ini

[sbeard]

When I edit the my.ini file with this statement:
set-variable=max_allowed_packet=16M, save it and restart the MySQL service. It fails to change the variable. I refresh the variables and it still has the default setting. When I do it from the command line using this:
mysqld-max-nt -O max_allowed_packet=16M
It works after I re-start the service. However, if I re-boot the server. It goes back to the default setting when it comes back up. Also, it doesnt come back to the command line after I run the command. I am running version 3.23.49 on a WinNT 4.0 server. Thanls

[nsr81]

I think the file name has to be "my.cnf" I'm not 100% sure about that though.

I've "my.cnf" with the following line and it works fine:

[mysqld]
set-variable = max_allowed_packet=16M

[eva2000]

you can have either my.ini or my.cnf

best to delete my.ini and move your settings into a file at c:\my.cnf

http://www.mysql.com/doc/en/Option_files.html

[sbeard]

There isnt a my.cnf at C:\ or C:\WINNT. Do I need to create one?

[sbeard]

I copied the settings to a file and saved it as my.cnf. Then I deleted the my.ini file from C:\WINNT. Then I restarted MySQL. The Change of set-variable=max_allowed_packet=16M did not take effect. I also tried running and it still did not take effect. Also when I re-booted the machine, it recreated on its own the my.ini file on the C:\WINNT folder.

[eva2000]

Originally posted by sbeard
I copied the settings to a file and saved it as my.cnf. Then I deleted the my.ini file from C:\WINNT. Then I restarted MySQL. The Change of set-variable=max_allowed_packet=16M did not take effect. I also tried running and it still did not take effect. Also when I re-booted the machine, it recreated on its own the my.ini file on the C:\WINNT folder. move it back to c:\winnt\my.ini

restart mysql and then type in command line

c:\path\to\mysql\bin\mysqladmin -u root -p variables

and post the output here (might want to use text editor to replace blank lines)

[sbeard]

I found a solution. I used the my-huge.cnf file. What I did was made the apporprate changed to the file and saved it as my.ini and placed it in the C:\WINNT folder. After that it worked fine. For some reason, Windows did not like it as a .cnf file, caused MySQL service to unexpectedly terminate when it tried to start.