Copying large datasets in Windows

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

--
Matt Bernhardt, bernhardt.7@osu.edu
Webmaster + Fab Lab Coordinator
Knowlton School of Architecture
The Ohio State University

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Copying large datasets in Windows

On 10/31/06, Matthew Bernhardt 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.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org