Navicat MySQL server has gone away

Navigation
0

I am creating a base de datos and at the moment of importing a file SQL with too many records or just that it is very heavy, I get 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 .

    
asked by Eduardo Javier Maldonado 21.06.2018 в 08:40
source

1 answer

0

The solution to the error 2006 is to increase the values max_allowed_packet and wait_timeout .

  • Press Tools > Server Monitor .
  • Check the box of the server you use for data transfer.
  • Click on the Variables tab.
  • Find the variables max_allowed_packet and wait_timeout .
  • Increase the values of these variables to a larger value and press OK .

    • With this the problem is completely solved because the tiempo de espera and the numero de paquetes máximo permitidos are increased.

        
    answered by 21.06.2018 / 08:40
    source
    Pattern finder [duplicate] Filter full calendar events