While trying to restore a mysql database I am getting the following error.
root@server [/var/lib/mysql]# mysql a24uall_data </home/a24uall/dbuploaded.sql
ERROR 1153 (08S01) at line 16985: Got a packet bigger than ‘max_allowed_packet’ bytes
Solution :
In my.cnf and add the following line :
set-variable = max_allowed_packet=32M and restart mysql
/etc/init.d/mysql restart