Re: importing large dump

2002-08-30 Thread David Phillips
rihad writes: > I digged thru the manual, and tried running mysql with the -O > max_allowed_packet=16M option as they suggested. Same thing. Exactly > same line. Always. > > I opened up the file in [beep] (a text editor) and can see nothing > wrong at line 1283716. It's the end of the previous ins

importing large dump

2002-08-30 Thread rihad
When I try to import a large (~180 mb) dump into mysql $ mysql -uuser -ppassword db_name < /tmp/all.sql It dies on me after 2 minutes with this: ERROR 2006 at line 1283716: MySQL server has gone away I digged thru the manual, and tried running mysql with the -O max_allowed_packet=16M option a