Re: Copying large datasets in Windows - Daniel da Veiga - com.mysql.lists.win32

2 messages in com.mysql.lists.win32Re: Copying large datasets in Windows

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

Subject:	Re: Copying large datasets in Windows
From:	Daniel da Veiga (dani...@gmail.com)
Date:	10/31/2006 09:55:28 AM
List:	com.mysql.lists.win32

On 10/31/06, Matthew Bernhardt <bern...@osu.edu> wrote:

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.

Is this database MyISAM or Innodb? With MyISAM you just need to copy the directory and change its name (of course), with Innodb, you can use mysqldump, and then redirect the resulting file into your server. Of course, you should ALWAYS copy your data dir, and have some kind of backup for emergency purposes. There's also a tool (can't remember its name) for innodb hotcopy... You can search for it.