my.cnf is where?

[Grunt]

Im attempting to resize my max_packets, but unable to find my.cnf within the SQLyog folders anywhere..using 3.64

??

[Ritesh]

my.cnf is a MySQL configuration file. SQLyog never uses it.

From the MySQL Docs:

Quote:

There are two option files with the same function: `C:my.cnf', and the `my.ini' file in the Windows directory. (This directory typically is named something like `C:WINDOWS' or `C:WinNT'. You can determine its exact location from the value of the WINDIR environment variable.)

[Grunt]

I am getting a: Error : Got a packet bigger than 'max_allowed_packet' when trying to execute a rather large batch file. i had thought i read in another thread that to correct this the 'max_allowed_packet' had to be adjusted in the my.cnf – i guess i was mistaken.

Regardless, could you point me in the right direction to get this sorted?

Just out of curiosity, looking in my.ini located in my winnt dir, theres no line for it either:

Code:

#This File was made using the WinMySQLAdmin 1.4 Tool
#2/23/2004 8:02:49 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=xxx.xxx.xxx.xx
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=xxxxxx

[Ritesh]

Check the following link:

Max_Allowed_Packet

[Shadow]

If you have my.ini then you have no nedd for my.cnf, the two are the same… If your my.ini does not have a max_allowed_packet definition, then MySql uses the default value. You have to add the parameter either manually or by using MySql Administrator.

[Author]

Posts