使用Navicat执行大数据量的sql文件时,会报错:
MySQL server has gone away

解决方案

修改mysql配置

  1. [mysqld]
  2. max_allowed_packet=50M
  3. wait_timeout=288000
  4. interactive_timeout = 288000