Copying large datasets in Windows

"Matthew Bernhardt" <[email protected]> Tue, 31 Oct 2006 09:41:52 -0500
Newsgroups gmane.comp.db.mysql.windows
Organization Knowlton School of Architecture
Message-ID <[email protected]>
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, [email protected]
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/[email protected]