Copying large datasets in Windows - Matthew Bernhardt - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Copying large datasets in Windows

From	Sent On	Attachments
Matthew Bernhardt	31 Oct 2006 06:41
Daniel da Veiga	31 Oct 2006 09:55

Subject:	Copying large datasets in Windows
From:	Matthew Bernhardt (bern...@osu.edu)
Date:	10/31/2006 06:41:29 AM
List:	com.mysql.lists.win32

Hello all,

I have a rather large table (29 million records, MySQL Administrator shows a data length of 4 Gb) which I need to make a copy of for analysis purposes. I've tried using the Backup function in the Admin to get a script I can then read into a separate server, but it died about 80% of the way through. SQLyog's copy routine died, earlier in the process. As a last resort, can I just copy the files from one server to the other from Windows itself? I seem to recall from the one training session I was at that this is an option, but I can't remember for sure - and don't want to break either server by just trying it without some research.

Thanks for any input, Matt