DebugAH

How to Solve Your Programmer Error

Skip to content
  • Home
  • Linux
  • JAVA
  • Python
  • Javasript
  • MYSQL
  • Windows
  • Error

[Solved] Windows10 Export Datas to MySQL Error: 2006 – MySQL server has gone away

Modify the configuration file my Ini, at the end of the [mysqld] section, modify the configuration parameters:

max_allowed_packet = 50M
interactive_timeout = 2880000
wait_timeout = 2880000

Restart the server and try to import again.

Similar Posts:

  • MySQL external import data error [How to Solve]
  • Error while sending query packet in PHP runtime
  • Error Code: 2006 – MySQL server has gone away
  • ERROR 2006 (HY000): MySQL server has gone away No
  • [Solved] MYSQL:1153 Got a packet bigger than ‘max_allowed_packet’ bytes
  • Mysql import Error Code: 2013 – Lost connection to MySQL server during query
  • [Solved] MYSQL:1153 Got a packet bigger than ‘max_allowed_packet’ bytes
  • Sqlog recovery database error solution [error code: 2006 – MySQL server has gone away]
  • [Solved] Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  • Navicat Import Datas Error: — 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

This entry was posted in Windows and tagged 2006 MySQL server has gone away, Windows10 Export Datas to MySQL Error on December 24, 2021 by Robins.

Post navigation

← [Solved] Webassembly cannot be opened in IOS 12 and below and debug error: referenceerror: cant find variable: globalthis [Solved] Linux Error: bash: Make: command not found →

Recent Posts

  • [Solved] The bean ‘sysDictService’ could not be injected because it is a JDK dynamic proxy
  • How to Use awk to Analyze Nginx Log
  • [Solved] Win-KeX/wsl2/kali Startup Error: A fatal error has occurred and VcXsrv will now exit.
  • [Solved] samtools: error while loading shared libraries: libcrypto.so.1.0.0: cannot open shared object file
  • k8s Error: [ERROR FileAvailable–etc-kubernetes-kubelet.conf]: /etc/kubernetes/kubelet.conf already exists
  • [Solved] NoSuchMethodError: org.springframework.boot.web.servlet.error.ErrorController.getErrorPath
  • [Solved] flink web ui Submit Task Error: Server Respoonse Message-Internal server error
  • Mysql Error: 1140 – In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column ‘a.store’; this is incompatible with sql_mode=only_full_group_by
  • [Solved] Mybatis multi-table query error: Column ‘id’ in field list is ambiguous
  • [Solved] fluentd Log Error: read timeout reached

Tags

  • )
  • android
  • android studio
  • CentOS
  • centos7
  • chrome
  • DebugAH
  • django
  • docker
  • eclipse
  • git
  • github
  • go
  • hadoop
  • Hive
  • IDEA
  • ios
  • java
  • jenkins
  • Linux
  • Mac
  • maven
  • MyBatis
  • mysql
  • nginx
  • No module named XXX error
  • npm
  • Oracle
  • php
  • pip
  • pycharm
  • Python
  • Python TypeError
  • redis
  • shell
  • spring
  • springBoot
  • ssh
  • SVN
  • tensorflow
  • tomcat
  • ubuntu
  • vue
  • Windows
  • Yum
Proudly powered by WordPress