On 3/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > When you generated this dump file, did you remember to use the > --max_allowed_packet parameter to make sure that mysqldump didn't create any > extended insert statements larger than your server wants to handle? It could > be crapping out because at line 1189 you exceeded max_allowed_packet. To be > safe always use a value of 16M or less when setting max_allowed_packet. > Check your server's variables for the value it's currently using > > SHOW VARIABLES LIKE 'max%'; > > I don't know for sure that this is going to be the problem but it's always > something to look at when you start dealing in larger dumpfiles.
I hadn't considered that. I think I'll also be dealing with net_buffer_length, since it seems that is what actually affects the dump insert statement size limit. I'll give it a whirl, thanks. -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
