We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
MySQL Error #2006
-
- Posts: 8
- Joined: Sun Dec 28, 2014 4:29 pm
- Contact:
MySQL Error #2006
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.
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.
-
- Posts: 88
- Joined: Thu Mar 06, 2014 7:52 pm
- Contact:
Re: MySQL Error #2006
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
Code: Select all
max_allowed_packet = 70M
-
- Posts: 8
- Joined: Sun Dec 28, 2014 4:29 pm
- Contact:
Re: MySQL Error #2006
Hi drMac,
Yes! Thanks, works fine!
;)
Yes! Thanks, works fine!
;)
-
- Posts: 88
- Joined: Thu Mar 06, 2014 7:52 pm
- Contact:
Re: MySQL Error #2006
No problem! We're on this planet to help each other, right?David Diaz wrote:Hi drMac,
Yes! Thanks, works fine!
;)
Have fun :)
-
- Posts: 8
- Joined: Sun Dec 28, 2014 4:29 pm
- Contact:
Re: MySQL Error #2006
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
In this case you need to update PHP-FPM setting under Vesta CP