This is confirmed working on a small test set with MySQL 4.1.22
transitioning from SPARC to X64. Thanks everyone!
-Aaron
Here's the test set we used:
CREATE TABLE `test_innodb` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`bigint` bigint(11) DEFAULT NULL,
`float` float DEFAULT NULL,
`double` double DEFAULT NULL,
`deci` decimal(6,2) DEFAULT NULL,
`var` varchar(255) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
`timestamp` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
big_unsigned bigint unsigned,
float_unsigned float unsigned,
int_unsigned int unsigned,
PRIMARY KEY (`id`),
KEY `deci` (`deci`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
insert into `test_innodb` values
('1' ,'9223372036854775807' ,'321.123' ,'123132321.213213' ,'12.20'
,'somehcar' ,'2009-02-10 10:44:10' ,'2009-02-17 10:46:05' ,(4000000 *
4000000) ,444.888 ,123456) ,
('2' ,'-9223372036854775807' ,'-67498.7' ,'-6.84616419684968e+17' ,'-0.84'
,'somevarchar' ,'2009-02-05 10:45:12' ,'2009-02-17 10:46:12' ,(5000000 *
3000000) ,444.888 ,123456) ,
('3' ,'0' ,'0.0' ,'0.0' ,'0.0' ,NULL ,'0000-00-00 00:00:00' ,'2009-02-17
10:46:12' ,(0) ,0.0 ,0);
On Mon, Feb 16, 2009 at 8:26 AM, Heikki Tuuri <heikki.tu...@oracle.com>wrote:
> Aaron,
>
> "
> 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?
>
> If a file copy doesn't work, why specificially would it fail?
>
> Thanks,
> -Aaron
> "
>
> you can simply copy the files, whether InnoDB or MyISAM. As far as I know,
> all modern processors use the same floating point format. And all integer
> and other data structures are platform independent in MyISAM and InnoDB.
>
> Best regards,
>
> Heikki
> Innobase/Oracle
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=aaronb...@gmail.com
>
>
