Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Find all posts by this user
Quote this message in a reply
10-15-2019, 07:43 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)