MySQL Packet Size 1.00 MB How do I change this???

[kellyandmark04]

MySQL Packet Size 1.00 MB vBulletin 3.8 How do I change this???

Please help step by step instructions please as I'm not familiar with this???

[Marco van Herwaarden]

You will need to ask your host to raise the limit in the MySQL configuration.

[kellyandmark04]

I have they said it is in the vbulletin files???

--------------- Added 1234258160 at 1234258160 ---------------

Even have it posted here and another member says the same

https://vborg.vbsupport.ru/showthread.php?t=203892

[Voltar]

If you have root access to the server, you need to change a value in /etc/my.cnf. That is the way to change the packet size. Either you or your host will have to do this.

Look for a directive called "max_allowed_packet" and set it to whatever you desire. It'll be under the [mysqld] configuration.

For example, this is taken from one of my servers

[mysqld]
<snip>
max_allowed_packet=24M
<snip>

http://img21.imageshack.us/img21/696/asdfev1.png

[kellyandmark04]

Thank you for the help.

Where do i find

/etc/my.cnf

[Dismounted]

I have they said it is in the vbulletin files???
The Packet Size is a MySQL Server Setting. It cannot be changed from inside vBulletin.

[Marco van Herwaarden]

Please don't start a new thread for the same issue. Your question have been answered a few times now, always with the same answer, but you keep repeating your question without listenening to the answers already given.

Your problem is caused by a low limit in the MySQL configuration. This can not be changed from vBulletin, but your host must change the MySQL configuration.

If your host claims something else, they obviously don't know what they are doing and you should consider a different host.

[Voltar]

Thank you for the help.


Where do i find

/etc/my.cnf

If you don't know by looking at that, then point your host to this thread. You need root level access to the server operating system to modify that file and restart the MySQL daemon.