It actually depends on your table types. With MyISAM it is no problem, but with InnoDB you are looking at a dump-and-restore..
Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Fri, Feb 13, 2009 at 6:23 PM, Kurt Cypher <kurt.cyp...@wright.edu> wrote: > On Feb 13, 2009, at 11:41 AM, Aaron Blew wrote: > >> All, >> I've currently got a project to migrate a LARGE (3.5TB) MySQL data set >> from >> a Sun SPARC machine to a Sun x86 machine, both running Solaris 10 (though >> obviously one is x86 and the other is SPARC). Is it possible to simply >> copy >> the data files from one host to the other or is a full mysqldump/import >> necessary to preserve data integrity? >> > > I have done straight data directory copy from server to server before > (granted they were both SPARC machines) and had no problem. Off-hand, I > can't think of any reason why it wouldn't work between SPARC & x86, both > running the same Solaris version, especially if they're both running the > same version of mySQL. > > I would suggest doing a test copy, if possible to see what happens. > > Kurt > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
