MySQL Error #2006

[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.

[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

[David Diaz]

Hi drMac,

Yes! Thanks, works fine!

;)

[drMacFaulty]

Hi drMac,

Yes! Thanks, works fine!

;)

No problem! We're on this planet to help each other, right?
Have fun :)

[David Diaz]

;)

[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