{"id":138,"date":"2009-10-01T17:21:05","date_gmt":"2009-10-01T21:21:05","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=138"},"modified":"2013-03-20T08:40:13","modified_gmt":"2013-03-20T12:40:13","slug":"got-a-packet-bigger-than-max_allowed_packet-bytes","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/got-a-packet-bigger-than-max_allowed_packet-bytes","title":{"rendered":"Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes"},"content":{"rendered":"<blockquote><p><span style=\"color: #993300;\"><strong>&#8220;Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes&#8221;<\/strong><\/span><\/p><\/blockquote>\n<p>The message is displayed when you try to restore a database and the packet size if more than the default one OR the one defined in the my.cnf file.You can check the existing bytes with the following command<\/p>\n<blockquote><p><span style=\"color: #993300;\"><strong>root@server [~]# mysqladmin variables | grep max_allowed_packet<br \/>\n| max_allowed_packet\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 1048576 <\/strong><\/span>|<\/p><\/blockquote>\n<p>To overcome the issue, add the following parameter in the my.cnf file<\/p>\n<blockquote><p><span style=\"color: #993300;\"><strong>max_allowed_packet = 2097152<\/strong><\/span><\/p><\/blockquote>\n<p>The value should be more than the default one. Save the file and restart the mysql service.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes&#8221;<br \/>\nThe message is displayed when you try to restore a database and the packet size if more than the default one OR the one defined in the my.cnf file.You can check the existing bytes with the following command<br \/>\nroot@server [~]# mysqladmin variables | grep max_allowed_packet<br \/>\n| max_allowed_packet\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 1048576 |<br \/>\nTo overcome the issue, add the following parameter in the my.cnf file<br \/>\nmax_allowed_packet = 2097152<br \/>\nThe value should be more than the default one. Save the file and restart the mysql service.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6,4],"tags":[153,154,155,156,157],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/138"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":3,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/138\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}