Answers.Body: <p>Your MySQL configuration has its <a href="https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_allowed_packet" rel="nofollow noreferrer">max_allowed_packet</a> config setting set to the default 42M (4194304).</p>
  
  <p>There's a query that executed for database backup that is slightly larger than that (about 44M).</p>
  
  <p>You'll need to increase that value in your MySQL config or ask your host if they can do it for you if you want to import the backup without any errors.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-05T16:59:33.143Z
Answers.Text: Thanks Brad. Could this larger than expected query be a symptom of a problem in my configuration or templates?
Answers.UserDisplayName: Brian Liddell
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-05T19:00:02.163Z
Answers.Text: Most like just a server side MySQL configuration issue.
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-05T03:40:54.640Z
Answers.LastActivityDate: 2018-08-05T15:28:06.900Z
Answers.LastEditDate: 2018-08-05T15:28:06.900Z
Answers.UserDisplayName: Brad Bell
Body: <p>I just copied my database across from local server to production server. I used Craft's control panel to create a backup. Then I used Sequel Pro to import this into the live server.
  I got this error:</p>
  
  <blockquote>
    <p>[ERROR in query 121] The query length of 4327045 bytes is larger than max_allowed_packet size (4194304).</p>
  </blockquote>
  
  <p>I clicked on 'Continue' and all looks OK on my live site.
  Can someone suggest what this might mean? Should I worry? What should I do?</p>
  
Tags: <mysql><import>
Title: Error on import to Craft production db
ThreadText: # Error on import to Craft production db
  
  (Asked by: username_0 on 2018-08-04)
  
  I just copied my database across from local server to production server. I used Craft's control panel to create a backup. Then I used Sequel Pro to import this into the live server.
  I got this error:
  
  > [ERROR in query 121] The query length of 4327045 bytes is larger than max\_allowed\_packet size (4194304).
  
  I clicked on 'Continue' and all looks OK on my live site.
  Can someone suggest what this might mean? Should I worry? What should I do?
  
  **Tags:** mysql, import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-08-05. Score: 1
  
  Your MySQL configuration has its [max\_allowed\_packet](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_allowed_packet) config setting set to the default 42M (4194304).
  
  There's a query that executed for database backup that is slightly larger than that (about 44M).
  
  You'll need to increase that value in your MySQL config or ask your host if they can do it for you if you want to import the backup without any errors.
  
  > **Comments:**
  > **username_0**: Thanks username_1. Could this larger than expected query be a symptom of a problem in my configuration or templates?  
  > **username_1**: Most like just a server side MySQL configuration issue.  
  
  ---
  
  