I stumbled over this a wile ago and submitted a patch. I'm not sure it ever got implemented.
According to the MySQL 5.6 Reference manual in relation to InnoDB tables: "ROW_FORMAT=FIXED is not supported. If ROW_FORMAT=FIXED is specified while innodb_strict_mode is disabled, InnoDB issues a warning and assumes ROW_FORMAT=COMPACT. If ROW_FORMAT=FIXED is specified while innodb_strict_mode is enabled, InnoDB returns an error". And a few lines later: "For MyISAM tables, the option value can be FIXED or DYNAMIC for static or variable-length row format. myisampack sets the type to COMPRESSED". Maybe the default in 5.7 changed to strict or the behaviour has been changed. I don't know. On Fri, Jan 8, 2016 at 4:02 PM, GarminKawaguichi < [email protected]> wrote: > May be that could help: > > http://bugs.mysql.com/bug.php?id=23404 > > GCI > > > Le 08/01/2016 12:11, Ai Austin a écrit : > > hello.. I have a working OpenSim database on MySQL 5.6.21 Community > Edition and have done a mysqldump on that. I set up a new server with > MySQL 5.7.10 Community Edition and created the opensim database as usual... > I then wanted to load in the dumped mysql from the other server. > > I got an error ERROR 1031 (HY000) at line 3016: Table storage engine for > 'regions' doesn't have this option > > I can't edit the very large SQL file to check what that line has on it, > but after looking round on the web a bit and using a suggestion there I did > get the create table statement for "regions" from the previous working > system and try to load that on the new MYSQL setup and that give the same > error... as noted in the trace below. So I assume its the table create for > the "regions" table that is the problem. But what is wrong? I can dump the > SQL from the original data base again if some parameter is needed there. > > Can anyone cast a light on this or suggest a fix? > > C:\Users\****> mysql --verbose -u ****** -p opensim < create-regions.sql > Enter password: ********* > -------------- > CREATE TABLE `regions` ( > `uuid` varchar(36) NOT NULL, > `regionHandle` bigint(20) unsigned NOT NULL, > `regionName` varchar(128) DEFAULT NULL, > `regionRecvKey` varchar(128) DEFAULT NULL, > `regionSendKey` varchar(128) DEFAULT NULL, > `regionSecret` varchar(128) DEFAULT NULL, > `regionDataURI` varchar(255) DEFAULT NULL, > `serverIP` varchar(64) DEFAULT NULL, > `serverPort` int(10) unsigned DEFAULT NULL, > `serverURI` varchar(255) DEFAULT NULL, > `locX` int(10) unsigned DEFAULT NULL, > `locY` int(10) unsigned DEFAULT NULL, > `locZ` int(10) unsigned DEFAULT NULL, > `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL, > `westOverrideHandle` bigint(20) unsigned DEFAULT NULL, > `southOverrideHandle` bigint(20) unsigned DEFAULT NULL, > `northOverrideHandle` bigint(20) unsigned DEFAULT NULL, > `regionAssetURI` varchar(255) DEFAULT NULL, > `regionAssetRecvKey` varchar(128) DEFAULT NULL, > `regionAssetSendKey` varchar(128) DEFAULT NULL, > `regionUserURI` varchar(255) DEFAULT NULL, > `regionUserRecvKey` varchar(128) DEFAULT NULL, > `regionUserSendKey` varchar(128) DEFAULT NULL, > `regionMapTexture` varchar(36) DEFAULT NULL, > `serverHttpPort` int(10) DEFAULT NULL, > `serverRemotingPort` int(10) DEFAULT NULL, > `owner_uuid` varchar(36) NOT NULL DEFAULT > '00000000-0000-0000-0000-000000000000', > `originUUID` varchar(36) DEFAULT NULL, > `access` int(10) unsigned DEFAULT '1', > `ScopeID` char(36) NOT NULL DEFAULT > '00000000-0000-0000-0000-000000000000', > `sizeX` int(11) NOT NULL DEFAULT '0', > `sizeY` int(11) NOT NULL DEFAULT '0', > `flags` int(11) NOT NULL DEFAULT '0', > `last_seen` int(11) NOT NULL DEFAULT '0', > `PrincipalID` char(36) NOT NULL DEFAULT > '00000000-0000-0000-0000-000000000000', > `Token` varchar(255) NOT NULL, > `parcelMapTexture` varchar(36) DEFAULT NULL, > PRIMARY KEY (`uuid`), > KEY `regionName` (`regionName`), > KEY `regionHandle` (`regionHandle`), > KEY `overrideHandles` > (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`), > KEY `ScopeID` (`ScopeID`), > KEY `flags` (`flags`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3' > -------------- > > ERROR 1031 (HY000) at line 1: Table storage engine for 'regions' doesn't > have this option > > _______________________________________________ > Opensim-users mailing list > [email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > > _______________________________________________ > Opensim-users mailing list > [email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > >
_______________________________________________ Opensim-users mailing list [email protected] http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
