{"id":6281,"date":"2021-05-22T15:31:05","date_gmt":"2021-05-22T10:01:05","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=6281"},"modified":"2021-05-22T15:31:09","modified_gmt":"2021-05-22T10:01:09","slug":"error-1153-08s01-at-line-8606-got-a-packet-bigger-than-max_allowed_packet-bytes","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/error-1153-08s01-at-line-8606-got-a-packet-bigger-than-max_allowed_packet-bytes\/","title":{"rendered":"ERROR 1153 (08S01) at line 8606: Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes."},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">ERROR 1153 (08S01) at line 8606: Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes.<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">Date: 22-05-2021<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">Introduction:<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">When doing a very large MySQL import from a dump file you may get this error. You can follow the below steps to solve this error.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"148\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-1024x148.png\" alt=\"\" class=\"wp-image-6282\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-1024x148.png 1024w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-300x43.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-768x111.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-850x123.png 850w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error-1200x174.png 1200w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/error.png 1203w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1:<\/strong> You can see the current configured maximum packet size for your installed mysql service. Log in to your MySQL shell with&nbsp;<em>root<\/em>&nbsp;privileges. Use below command to get value in MB. <br><strong><code>mysql&gt; SELECT @@max_allowed_packet \/ 1024 \/ 1024;<\/code><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In below image has 1MB value you need to change this value to 100MB.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1.png\"><img decoding=\"async\" width=\"942\" height=\"670\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1.png\" alt=\"\" class=\"wp-image-6284\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1.png 942w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1-300x213.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1-768x546.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-1.46.42-PM-1-422x300.png 422w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2:<\/strong>  Login to the server and edit the <strong><code>\/etc\/mysql\/my.cnf or \/etc\/my.cnf or my.ini <\/code><\/strong>file&nbsp;under the mysqld section and add below detail.<br><strong><code>max_allowed_packet=100M<\/code><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM.png\"><img decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM-1024x360.png\" alt=\"\" class=\"wp-image-6285\" srcset=\"https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM-1024x360.png 1024w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM-300x105.png 300w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM-768x270.png 768w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM-850x300.png 850w, https:\/\/pheonixsolutions.com\/blog\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-22-at-2.01.55-PM.png 1098w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3:<\/strong> Restart the mysql service to apply these settings in server. You can verify this value as changed to 100 MB by using command in Step 1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong> You can change the maximum allowed packet size when running the&nbsp;mysql&nbsp;below command as a parameter. This increases the maximum packets value that client will send to the server.<br><strong><code># mysql --max_allowed_packet=100M DBname &lt; Dump file.sql<\/code><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ERROR 1153 (08S01) at line 8606: Got a packet bigger than &#8216;max_allowed_packet&#8217; bytes. Date: 22-05-2021 Introduction: When doing a very [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[180,864,863,862,584],"class_list":["post-6281","post","type-post","status-publish","format-standard","hentry","category-web-architecture","tag-database","tag-database-restore","tag-dump-file-import","tag-max_allowed_packet-value","tag-mysqldb","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-1Dj","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6281"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6281\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}