View Single Post

  #1 (permalink)  
Old 05-13-2007
laredotornado@zipmail.com
 
Posts: n/a
Default 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

Reply With Quote