While restoring mysql database, you may get this error.
MySQL server has gone away
or
MySQL: got a packet bigger than ‘max_allowed_packet’ bytes
Fix:
You need to increase mysql variables max_allowed_packet and global net_buffer_length in mysql database
Login is root and set this.
mysql> set global max_allowed_packet=2000000000;
mysql> set global net_buffer_length=2000000;
MySQL server has gone away
or
MySQL: got a packet bigger than ‘max_allowed_packet’ bytes
Fix:
You need to increase mysql variables max_allowed_packet and global net_buffer_length in mysql database
Login is root and set this.
mysql> set global max_allowed_packet=2000000000;
mysql> set global net_buffer_length=2000000;