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:[EMAIL PROTECTED] 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/[EMAIL PROTECTED]
