<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#FF0000" bgcolor="#FFFFFF">
May be that could help:<br>
<br>
<a class="moz-txt-link-freetext" href="http://bugs.mysql.com/bug.php?id=23404">http://bugs.mysql.com/bug.php?id=23404</a><br>
<br>
GCI<br>
<br>
<div class="moz-cite-prefix">Le 08/01/2016 12:11, Ai Austin a
écrit :<br>
</div>
<blockquote
cite="mid:568f9974.84e31c0a.56c09.fffffda6@mx.google.com"
type="cite">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.
<br>
<br>
I got an error ERROR 1031 (HY000) at line 3016: Table storage
engine for 'regions' doesn't have this option
<br>
<br>
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.
<br>
<br>
Can anyone cast a light on this or suggest a fix?
<br>
<br>
C:\Users\****> mysql --verbose -u ****** -p opensim <
create-regions.sql
<br>
Enter password: *********
<br>
--------------
<br>
CREATE TABLE `regions` (
<br>
`uuid` varchar(36) NOT NULL,
<br>
`regionHandle` bigint(20) unsigned NOT NULL,
<br>
`regionName` varchar(128) DEFAULT NULL,
<br>
`regionRecvKey` varchar(128) DEFAULT NULL,
<br>
`regionSendKey` varchar(128) DEFAULT NULL,
<br>
`regionSecret` varchar(128) DEFAULT NULL,
<br>
`regionDataURI` varchar(255) DEFAULT NULL,
<br>
`serverIP` varchar(64) DEFAULT NULL,
<br>
`serverPort` int(10) unsigned DEFAULT NULL,
<br>
`serverURI` varchar(255) DEFAULT NULL,
<br>
`locX` int(10) unsigned DEFAULT NULL,
<br>
`locY` int(10) unsigned DEFAULT NULL,
<br>
`locZ` int(10) unsigned DEFAULT NULL,
<br>
`eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
<br>
`westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
<br>
`southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
<br>
`northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
<br>
`regionAssetURI` varchar(255) DEFAULT NULL,
<br>
`regionAssetRecvKey` varchar(128) DEFAULT NULL,
<br>
`regionAssetSendKey` varchar(128) DEFAULT NULL,
<br>
`regionUserURI` varchar(255) DEFAULT NULL,
<br>
`regionUserRecvKey` varchar(128) DEFAULT NULL,
<br>
`regionUserSendKey` varchar(128) DEFAULT NULL,
<br>
`regionMapTexture` varchar(36) DEFAULT NULL,
<br>
`serverHttpPort` int(10) DEFAULT NULL,
<br>
`serverRemotingPort` int(10) DEFAULT NULL,
<br>
`owner_uuid` varchar(36) NOT NULL DEFAULT
'00000000-0000-0000-0000-000000000000',
<br>
`originUUID` varchar(36) DEFAULT NULL,
<br>
`access` int(10) unsigned DEFAULT '1',
<br>
`ScopeID` char(36) NOT NULL DEFAULT
'00000000-0000-0000-0000-000000000000',
<br>
`sizeX` int(11) NOT NULL DEFAULT '0',
<br>
`sizeY` int(11) NOT NULL DEFAULT '0',
<br>
`flags` int(11) NOT NULL DEFAULT '0',
<br>
`last_seen` int(11) NOT NULL DEFAULT '0',
<br>
`PrincipalID` char(36) NOT NULL DEFAULT
'00000000-0000-0000-0000-000000000000',
<br>
`Token` varchar(255) NOT NULL,
<br>
`parcelMapTexture` varchar(36) DEFAULT NULL,
<br>
PRIMARY KEY (`uuid`),
<br>
KEY `regionName` (`regionName`),
<br>
KEY `regionHandle` (`regionHandle`),
<br>
KEY `overrideHandles`
(`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),<br>
KEY `ScopeID` (`ScopeID`),
<br>
KEY `flags` (`flags`)
<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
COMMENT='Rev. 3'
<br>
--------------
<br>
<br>
ERROR 1031 (HY000) at line 1: Table storage engine for 'regions'
doesn't have this option
<br>
<br>
_______________________________________________
<br>
Opensim-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@opensimulator.org">Opensim-users@opensimulator.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users">http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users</a>
<br>
<br>
</blockquote>
</body>
</html>