#2006 - MySQL server has gone away

[alanmi3833]

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

[falkoner]

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