[Opensim-users] MySQL create table for regions fails on new data base setup?

[Ai Austin]

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