Apache Friends Support Forum

Hello, I'm using 1.5.5 version which is works perfectly for me on my winXP..My question is how to increase max_allowed_packet=1M
to max_allowed_packet=ANYTHING

I also notice that we can change it via my.cnf file. But I don't know how to that because most of the instructions are based on Linux command.

Your help is highly appreciated..


Regards,
sila

I also notice that we can change it via my.cnf file. But I don't know how to that because most of the instructions are based on Linux command.

Just open the "my.cnf" in your editor and change the value for "max_allowed_packet".

(BTW: "ANYTHING" is not a allowed value)

Sorry but I cannot find the my.cnf files in mysql/bin diretory.
I repeat I'm on Win32 platform

Thanks for your reply

I repeat I'm on Win32 platform

Me too.

but I cannot find the my.cnf files in mysql/bin diretory.

Then you have deleted this file or you have no XAMPP.

I cannot find it..Can you tell me where is the exactly location for my.cnf?
I found 2 files "my" and "my_example" in mysql/bin directory but couldn't open it with notepad

I found 2 files "my" and "my_example" in mysql/bin

"my" is the file you are searching for.

Wiedmann wrote:

I found 2 files "my" and "my_example" in mysql/bin

"my" is the file you are searching for.

I could not edit the 'my' file. It's like a short-cut icons. What text editor to use? I tried both, wordpad and notepad but still could not edit the ;my' file.

Thanks a lot

What text editor to use? I tried both, wordpad and notepad

You can use both.

BTW:
"wordpad" is not the best idea, to edit plain text files.