upload database error 1153

[clearchanel]

This is the complete error I am getting

ERROR 1153 (08S01) at line 5503: Got a packet bigger than 'max_allowed_packet' bytes

This happens during the insertation of the post table which is I believe 400+ megs.

Does anyone have a solution to this problem?

[JonnyThunder]

Is this during a restore of a populated database?

Also seems to be other posts on this forum about the same issue, like this one

[clearchanel]

OK, I gather from what I read I need to change the max packet size in my.cnf.

I managed to find and open the file but I do not see a reference to mass packet size. Am I supposed to add specfic syntax to set a max packet size, and what snytas and where do I place it?

Thanks in advance.

[Steve Machol]

Create a line with:

max_allowed_packet = 32M

Then restart MySQL.

[clearchanel]

I think I accomplished the my.cnf edit correctly. Do I need to make any changes to php.ini?

[Steve Machol]

Not unless you are getting a new error.