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

[GarminKawaguichi]

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
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20160108/5faddcca/attachment.html>