#2006 - MySQL server has gone away - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: #2006 - MySQL server has gone away (/showthread.php?tid=8373) |
#2006 - MySQL server has gone away - alanmi3833 - 10-15-2019 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. [attachment=1008] Ok solved that one Edit my.cnf and changed the following Quote:max_allowed_packet=1Mto Quote:max_allowed_packet=256M RE: #2006 - MySQL server has gone away - TimSchofield - 10-15-2019 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 |