#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=1Mto Quote:max_allowed_packet=256M |
|||
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 |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 1 Guest(s)