ERROR 2006 (HY000) at line 347: MySQL server has gone away

[webviri]

Hello,

Im trying to replace a huge database via SSL and im getting the following error "ERROR 2006 (HY000) at line 347: MySQL server has gone away".

i have modified my.cnf file under etc/my.cnf is it the correct location or wrong?

i have also increased my wait_timeout and also increased my max_allowed_packet

is there any changes have to be made..?



Thanks!

 

[IgorG]

Try to increase wait_timeout in /etc/my.cnf more.

 

[webviri]

Hello IgorG,

Thanks for your reply,


the content of my.cnf is:

[mysqld]
wait_timeout = 9000000
max_allowed_packet = 10240M
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
wait_timeout = 9000000
max_allowed_packet = 10240M

[mysql]
wait_timeout = 9000000
max_allowed packet = 10240M


is it okey? kindly confirm please