I am creating one base de datos
and when importing a file SQL
with too many records or simply too heavy, it throws me the following error:
[Err] [Dtf] 2006 - MySQL server has gone away
It is worth mentioning that I am using Navicat to manage the Base de Datos
.
The solution to the error
2006
is to increase the valuesmax_allowed_packet
andwait_timeout
.Tools > Server Monitor
.Variables
.max_allowed_packet
andwait_timeout
.OK
.With this the problem is totally solved because the
tiempo de espera
and the are increasednumero de paquetes máximo permitidos
.