Ah yes. From Perl I got the "server went away" error when inserting large entries. From the command line, I simply got "ERROR at line 1:" when I would construct the insert statment and place it in a text file to be run as: mysql -p -D myDBm < mybiginsert.sql
I didn't realize there was a max_allowed_packet parameter. Thanks, Chris On Mon, 5 Jan 2004, Keith C. Ivey wrote: > On 5 Jan 2004 at 13:06, Chris Seidel wrote: > > > However, I found my inserts failing when some of my > > strings exceeded 1 MB (e.g. a string of 1125921 bytes fails, while a > > string of 1009684 bytes succeeds). > > What error are you getting? It sounds like you haven't changed > max_allowed_packet from the default value of 1M. I believe that > earlier versions of MySQL seomtimes gave "server went away" error in > that circumstance rather than "packet too large". > > -- > Keith C. Ivey <[EMAIL PROTECTED]> > Tobacco Documents Online > http://tobaccodocuments.org > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
