Page 1 of 1
MySQL Error #2006
Posted: Sun Dec 28, 2014 4:33 pm
by David Diaz
Hi,
I am trying to import a MySQL database ( 65MB ), but I get error PhpMyAdmin:
#2006 - MySQL server has gone away
I need to change the value "max_allowed_packet", but do not know where it is.
Does anyone know ?
Thanks.
Re: MySQL Error #2006
Posted: Sun Dec 28, 2014 5:59 pm
by drMacFaulty
I think you need to change /etc/mysql/my.cnf (on debian) for this and add:
Source:
http://dev.mysql.com/doc/refman/5.5/en/ ... large.html
Re: MySQL Error #2006
Posted: Sun Dec 28, 2014 6:08 pm
by David Diaz
Hi drMac,
Yes! Thanks, works fine!
;)
Re: MySQL Error #2006
Posted: Sun Dec 28, 2014 6:49 pm
by drMacFaulty
David Diaz wrote:Hi drMac,
Yes! Thanks, works fine!
;)
No problem! We're on this planet to help each other, right?
Have fun :)
Re: MySQL Error #2006
Posted: Sun Dec 28, 2014 9:07 pm
by David Diaz
;)
Re: MySQL Error #2006
Posted: Wed Jul 25, 2018 7:26 pm
by imagpt
It does not work if your are using Nginx+PHP-FPM server.
In this case you need to update PHP-FPM setting under Vesta CP