<div dir="ltr"><div>I stumbled over this a wile ago and submitted a patch. I'm not sure it ever got implemented.</div><div><br></div><div>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".</div><div><br></div><div>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".</div><div><br></div><div>Maybe the default in 5.7 changed to strict or the behaviour has been changed. I don't know.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 8, 2016 at 4:02 PM, GarminKawaguichi <span dir="ltr"><<a href="mailto:garmin.kawaguichi@magalaxie.com" target="_blank">garmin.kawaguichi@magalaxie.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#FF0000">
May be that could help:<br>
<br>
<a href="http://bugs.mysql.com/bug.php?id=23404" target="_blank">http://bugs.mysql.com/bug.php?id=23404</a><br>
<br>
GCI<div><div class="h5"><br>
<br>
<div>Le 08/01/2016 12:11, Ai Austin a
écrit :<br>
</div>
<blockquote 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 href="mailto:Opensim-users@opensimulator.org" target="_blank">Opensim-users@opensimulator.org</a>
<br>
<a href="http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users" target="_blank">http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users</a>
<br>
<br>
</blockquote>
</div></div></div>
<br>_______________________________________________<br>
Opensim-users mailing list<br>
<a href="mailto:Opensim-users@opensimulator.org">Opensim-users@opensimulator.org</a><br>
<a href="http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users" target="_blank" rel="noreferrer">http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users</a><br>
<br></blockquote></div><br></div>