Re: mysqldump: lost connection & porting database from one server to another - Thimble Smith - com.mysql.lists.mysql

10 messages in com.mysql.lists.mysqlRe: mysqldump: lost connection & port...

From	Sent On	Attachments
Szymon Grabowski	15 Mar 2000 09:49
sas...@mysql.com	15 Mar 2000 13:26
Szymon Grabowski	15 Mar 2000 14:26
sas...@mysql.com	15 Mar 2000 14:49
Szymon Grabowski	16 Mar 2000 01:49
sas...@mysql.com	16 Mar 2000 02:12
sin...@mysql.com	16 Mar 2000 06:55
Szymon Grabowski	16 Mar 2000 10:17
sin...@mysql.com	16 Mar 2000 10:39
Thimble Smith	16 Mar 2000 12:08

Subject:	Re: mysqldump: lost connection & porting database from one server to another
From:	Thimble Smith (ti...@mysql.com)
Date:	03/16/2000 12:08:45 PM
List:	com.mysql.lists.mysql

On Thu, Mar 16, 2000 at 07:17:42PM +0100, Szymon Grabowski wrote:

I tried to move the database this way:

#1 mysqldump --quick getresponse prospects | gzip >prospects.gz (on the OLD server)

#2 gunzip < prospects.gz | mysql getresponse (on the NEW server)

while #1 was very fast (about 15 minutes), #2 took several hours. It was strange, because #2 accomplished the first 50% pretty fast and then it DRAMATICALLY slowed down. Is there any reason for that? Can I fix it?

Can you drop all indexes from the table, then perform the insert? Then add the indexes back. It might perform much better. There are several hints on how to speed up inserts in the manual (look at the `Insert speed' section).

Tim