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]