Strange error: Got a packet bigger than 'max_allowed_packet' bytes
Hi,
I'm using MySQL 5.0. I'm trying to import a file exported from
phpMyAdmin. The error I'm getting is:
ERROR 1153 (08S01) at line 418: Got a packet bigger than
'max_allowed_packet' bytes
Line 418 is an INSERT statement. It is very long so I won't post it
here. My inclination is that the length of the line is causing the
error. I'm turning to you experts, however, to see if there's some
setting I can adjust somewhere that will allow me to import this file
or if I must break up the file.
Thanks for any advice, - Dave
|