How to increase max_allowed_packet

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to increase max_allowed_packet

Postby sila » 07. March 2007 06:27

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

:lol:
Regards,
sila
sila
 
Posts: 7
Joined: 05. October 2006 17:57

Postby Wiedmann » 07. March 2007 08:14

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)
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby sila » 21. March 2007 18:56

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

Thanks for your reply
sila
 
Posts: 7
Joined: 05. October 2006 17:57

Postby Wiedmann » 21. March 2007 19:48

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.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby sila » 22. March 2007 12:20

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 :cry:
sila
 
Posts: 7
Joined: 05. October 2006 17:57

Postby Wiedmann » 22. March 2007 14:10

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

"my" is the file you are searching for.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby sila » 28. March 2007 18:26

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 :P
sila
 
Posts: 7
Joined: 05. October 2006 17:57

Postby Wiedmann » 28. March 2007 18:53

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.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 141 guests