ERROR 1153 (08S01) at line 16985: Got a packet bigger than ‘max_allowed_packet’ bytes

ARUN Post in MYSQL
0

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
« Prev: :Next »

Leave a Reply

You must be logged in to post a comment.