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
