getting following error when resotring from cpanel backup

[Amit]

Unable to restore database carzexco_carwp.sql to carzexco_carwp : ERROR 2006 (HY000) at line 111 in file: '/home/carzexco/backups/backup/carzexco_carwp.sql': MySQL server has gone away

 

[anay]

Its probably a large database. You may have to check mysql logs while restoring, could be low number of connection limit or memory , at first looks like resource related issue.

 

[smtalk]

I think it could be max_allowed_packet related, just increase it in mysql configuration and it should be okay then

 

[Amit]

How can I increase the max_allowed_packet in directadmin and what is default size in directadmin.

 

[anay]

Its in /etc/my.cnf

There is a small guide also for DA here: https://help.directadmin.com/item.php?id=44

 

[Amit]

Its in /etc/my.cnf

There is a small guide also for DA here: https://help.directadmin.com/item.php?id=44

When open my /etc/my. cnf it is blank please tell me what to add inside it.

 

[Zhenyapan]

When open my /etc/my. cnf it is blank please tell me what to add inside it.

so edit /etc/my.cnf.d/server.cnf