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