MSUK1 Posted December 27, 2012 Share Posted December 27, 2012 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 Quote Link to comment https://forums.phpfreaks.com/topic/272396-phpmyadmin-got-a-packet-bigger-than-max_allowed_packet-bytes/ Share on other sites More sharing options...
requinix Posted December 27, 2012 Share Posted December 27, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/272396-phpmyadmin-got-a-packet-bigger-than-max_allowed_packet-bytes/#findComment-1401499 Share on other sites More sharing options...
MSUK1 Posted December 28, 2012 Author Share Posted December 28, 2012 Thanks for the response, i think i'll do as you suggested split the sql into several partitions. Quote Link to comment https://forums.phpfreaks.com/topic/272396-phpmyadmin-got-a-packet-bigger-than-max_allowed_packet-bytes/#findComment-1401825 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.