While restoring database “ERROR 1153 (08S01) at line 233: Got a packet bigger than ‘max_allowed_packet’ bytes”
————————————————————————————————-

Open a terminal.
Type mysql to get a mysql prompt, and issue these commands
mysql> set global max_allowed_packet=1000000000;
Then restart mysql service.