RE: Import of a mysldump file fails

[Rolando Edwards]

In this case, the command for the second suggestion is

gzip -d < slavesetup.sql.gz | mysql -u <user> --password=<password>
<database name>

-----Original Message-----
From: Eramo, Mark [mailto:meramo@stripped]
Sent: Monday, May 05, 2008 3:40 PM
To: Mysql
Cc: Kieran Kelleher
Subject: RE: Import of a mysldump file fails

Hi Kieran,
   Try the following 2 things...

1) Add this to your my.cnf / my.ini in the [mysqld] section

max_allowed_packet=32M

(you might have to set this value higher based on your existing database).


2) If the import still does not work, try it like this as well.....

mysql -u <user> --password=<password> <database name> <
file_to_import

These should help you get by this issue. I use both of these to import a MySQL 4.0.20 dump
into MySQL 5.0

Mark


-----Original Message-----
From: Kieran Kelleher [mailto:kieran_lists@stripped]
Sent: Monday, May 05, 2008 3:21 PM
To: Mysql
Subject: Import of a mysldump file fails

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1