Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
#2006 - MySQL server has gone away
10-15-2019, 07:29 AM, (This post was last modified: 10-15-2019, 07:37 AM by alanmi3833.)
#1
#2006 - MySQL server has gone away
I am having trouble migrating my dataset to Linux getting the following error.
Running LinuxMint
RELEASE=19.1
CODENAME=tessa
EDITION="Cinnamon"
DESCRIPTION="Linux Mint 19.1 Tessa"
DESKTOP=Gnome
TOOLKIT=GTK
NEW_FEATURES_URL=https://www.linuxmint.com/rel_tessa_cinnamon_whatsnew.php
RELEASE_NOTES_URL=https://www.linuxmint.com/rel_tessa_cinnamon.php
USER_GUIDE_URL=https://www.linuxmint.com/documentation.php
GRUB_TITLE=Linux Mint 19.1 Cinnamon

See screenshot.
   
Ok solved that one
Edit my.cnf and changed the following
Quote:max_allowed_packet=1M
to
Quote:max_allowed_packet=256M
Reply
10-15-2019, 07:43 AM,
#2
RE: #2006 - MySQL server has gone away
Hi Alan,

One possibility here is to increase the size of the max_allowed_packet setting. I am using Linux Mint, but use mariadb. On my system that setting is in the file /etc/mysql/mariadb.conf.d/50-server.cnf so you should find it somewhere like /etc/mysql/mysql.conf.d/50-server.cnf

By default it was set to 16M try increasing this to 60M. You will need to restart the mysql daemon after you change it.

Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)