Phpmyadmin Got A Packet Bigger Than 'max_Allowed_Packet' Bytes
Posted 27 December 2012 - 03:47 AM
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
Posted 27 December 2012 - 11:00 AM
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.
Posted 28 December 2012 - 03:39 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users