Got a packet bigger than ‘max_allowed_packet’ bytes

“Got a packet bigger than ‘max_allowed_packet’ bytes”

The message is displayed when you try to restore a database and the packet size if more than the default one OR the one defined in the my.cnf file.You can check the existing bytes with the following command

root@server [~]# mysqladmin variables | grep max_allowed_packet
| max_allowed_packet | 1048576 |

To overcome the issue, add the following parameter in the my.cnf file

max_allowed_packet = 2097152

The value should be more than the default one. Save the file and restart the mysql service.