<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>

CC BY-SA 4.0
2018-08-05T16:59:33.143Z
Thanks Brad. Could this larger than expected query be a symptom of a problem in my configuration or templates?
Brian Liddell
CC BY-SA 4.0
2018-08-05T19:00:02.163Z
Most like just a server side MySQL configuration issue.
Brad Bell
CC BY-SA 4.0
2018-08-05T03:40:54.640Z
2018-08-05T15:28:06.900Z
2018-08-05T15:28:06.900Z
Brad Bell
<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>

<mysql><import>
Error on import to Craft production db
# 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 Brad. 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.  

---

