2 replies to this topic

[MSUK1]

Hello

I am trying to upload an SQL file to my new VPS. However i keep getting this error:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

I've contacted my host and they've said phps upload limit is 2M and the packetsize is too small

Ive checked my php ini file, upload size is 128M and the packet max is 16M

What am i doing wrong?

The filesize is just over 2MB

[requinix]

That's a MySQL error about a MySQL setting. Not related to PHP. Do a query

SHOW VARIABLES LIKE 'max_allowed_packet'

to see what it's set at (measured in bytes).

Assuming that won't change and/or is set to something reasonable (fair assumptions) work around the limit by splitting your SQL file into smaller pieces and running them individually.

[MSUK1]

Thanks for the response, i think i'll do as you suggested split the sql into several partitions.