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:

Code: Select all

max_allowed_packet = 70M
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