Import of a mysldump file fails

[Kieran Kelleher]

Hi,

I have a weird one going on here. I have done this many times before  
with MySQL 4.1, but now that I am trying to accomplish same task with  
a MySQL 5.0.x setup, mysql is just not succeeding in importing the  
mysqldump file.

I am doing a full mysql dump from a mysql master running 5.0.51a on a  
OS X 10.4.x Server PowerPC G4 XServe. The total size of all databases  
is around 17GB. I compress on the fly with gzip to create a 2.4GB  
compressed dump using this command.... the largest database is all  
innodb and the 2nd largest is myisam... so this is mixed innodb and  
myisam server.

$ mysqldump -u root -p<password> --all-databases --extended-insert -- 
add-locks --lock-all-tables --flush-logs --master-data=1 --add-drop- 
table --create-options --quick --set-charset --disable-keys --quote- 
names | gzip > slavesetup.sql.gz &

I am then copying this compressed dump to a MacMini Intel (aka slave)  
which has a clean install of 5.0.51b and importing into the mysql  
server. The import ran for a while and I then notice at some stage (by  
looking at top or "show processlist" that importing has completed)  
However checking the databases, only some of them have been imported  
(about 6GB of data) and the import has mysteriously stopped in the  
middle of importing the largest database. The import command is  
straightforward.......

$ gunzip < slavesetup.sql.gz | mysql -u root -h localhost -p<password> &

The *.err files inside the data dir have nothing to indicate what the  
problem is.

The error I get is in terminal is:
ERROR 2013 (HY000) at line 570: Lost connection to MySQL server during  
query

Any clues as to what might be going on here and why this might be  
happening? Any alternative or workaround suggestions?

Regards, Kieran