# ERROR 2006 (HY000): MySQL server has gone away

**URL:** <https://www.isharkfly.com/t/error-2006-hy000-mysql-server-has-gone-away/8065>\
**Category:** 数据库\
**Tags:** mariadb, mysql\
**Created:** [July 24, 2015, 4:13am UTC](https://www.isharkfly.com/t/error-2006-hy000-mysql-server-has-gone-away/8065 "2015-07-24T04:13:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [July 24, 2015, 4:13am UTC](https://www.isharkfly.com/t/error-2006-hy000-mysql-server-has-gone-away/8065/1 "2015-07-24T04:13:03Z")

</div>

数据在导入和导出出现下面的错误：

ERROR 2006 (HY000): MySQL server has gone away

日志如下：

```auto
mysql> source file.sql
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: ***NONE***

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: ***NONE***

```

这是因为你 `max_allowed_packet=64M` 的没有设置好。

你可以设置这个值为更大的值，那么在数据导入和导出的时候就不会出现上面的错误。
