6 added 6002 characters in body
source | link

SHOW CREATE TABLE from OLD server:

Table   Create Table
ReferenceDatabase_2_name        CREATE TABLE `ReferenceDatabase_2_name` (
  `DB_ID` int(10) unsigned DEFAULT NULL,
  `name_rank` int(10) unsigned DEFAULT NULL,
  `name` mediumtext COLLATE utf8_unicode_ci,
  KEY `DB_ID` (`DB_ID`),
  KEY `name` (`name`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
ReferenceEntity CREATE TABLE `ReferenceEntity` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `identifier` mediumtext COLLATE utf8_unicode_ci,
  `referenceDatabase` int(10) unsigned DEFAULT NULL,
  `referenceDatabase_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DB_ID`),
  KEY `referenceDatabase` (`referenceDatabase`),
  KEY `identifier` (`identifier`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
DatabaseObject  CREATE TABLE `DatabaseObject` (
  `DB_ID` int(10) NOT NULL AUTO_INCREMENT,
  `_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `_displayName` mediumtext COLLATE utf8_unicode_ci,
  `_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created` int(10) unsigned DEFAULT NULL,
  `created_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stableIdentifier` int(10) unsigned DEFAULT NULL,
  `stableIdentifier_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DB_ID`),
  KEY `_class` (`_class`),
  KEY `_timestamp` (`_timestamp`),
  KEY `created` (`created`),
  KEY `_displayName` (`_displayName`(10)),
  KEY `stableIdentifier` (`stableIdentifier`)
) ENGINE=MyISAM AUTO_INCREMENT=11631469 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
ReferenceSequence       CREATE TABLE `ReferenceSequence` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `species` int(10) unsigned DEFAULT NULL,
  `species_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sequenceLength` int(10) DEFAULT NULL,
  `isSequenceChanged` mediumtext COLLATE utf8_unicode_ci,
  `checksum` mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`DB_ID`),
  KEY `species` (`species`),
  KEY `sequenceLength` (`sequenceLength`),
  KEY `isSequenceChanged` (`isSequenceChanged`(10)),
  KEY `checksum` (`checksum`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
Species CREATE TABLE `Species` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `abbreviation` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`DB_ID`),
  KEY `abbreviation` (`abbreviation`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
Taxon_2_name    CREATE TABLE `Taxon_2_name` (
  `DB_ID` int(10) unsigned DEFAULT NULL,
  `name_rank` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `DB_ID` (`DB_ID`),\n  KEY `name` (`name`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

SHOW CREATE TABLE from NEW server is identical to OLD server.

SHOW CREATE TABLE from OLD server:

Table   Create Table
ReferenceDatabase_2_name        CREATE TABLE `ReferenceDatabase_2_name` (
  `DB_ID` int(10) unsigned DEFAULT NULL,
  `name_rank` int(10) unsigned DEFAULT NULL,
  `name` mediumtext COLLATE utf8_unicode_ci,
  KEY `DB_ID` (`DB_ID`),
  KEY `name` (`name`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
ReferenceEntity CREATE TABLE `ReferenceEntity` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `identifier` mediumtext COLLATE utf8_unicode_ci,
  `referenceDatabase` int(10) unsigned DEFAULT NULL,
  `referenceDatabase_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DB_ID`),
  KEY `referenceDatabase` (`referenceDatabase`),
  KEY `identifier` (`identifier`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
DatabaseObject  CREATE TABLE `DatabaseObject` (
  `DB_ID` int(10) NOT NULL AUTO_INCREMENT,
  `_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `_displayName` mediumtext COLLATE utf8_unicode_ci,
  `_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created` int(10) unsigned DEFAULT NULL,
  `created_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stableIdentifier` int(10) unsigned DEFAULT NULL,
  `stableIdentifier_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`DB_ID`),
  KEY `_class` (`_class`),
  KEY `_timestamp` (`_timestamp`),
  KEY `created` (`created`),
  KEY `_displayName` (`_displayName`(10)),
  KEY `stableIdentifier` (`stableIdentifier`)
) ENGINE=MyISAM AUTO_INCREMENT=11631469 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
ReferenceSequence       CREATE TABLE `ReferenceSequence` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `species` int(10) unsigned DEFAULT NULL,
  `species_class` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sequenceLength` int(10) DEFAULT NULL,
  `isSequenceChanged` mediumtext COLLATE utf8_unicode_ci,
  `checksum` mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`DB_ID`),
  KEY `species` (`species`),
  KEY `sequenceLength` (`sequenceLength`),
  KEY `isSequenceChanged` (`isSequenceChanged`(10)),
  KEY `checksum` (`checksum`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
Species CREATE TABLE `Species` (
  `DB_ID` int(10) unsigned NOT NULL DEFAULT '0',
  `abbreviation` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`DB_ID`),
  KEY `abbreviation` (`abbreviation`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Table   Create Table
Taxon_2_name    CREATE TABLE `Taxon_2_name` (
  `DB_ID` int(10) unsigned DEFAULT NULL,
  `name_rank` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `DB_ID` (`DB_ID`),\n  KEY `name` (`name`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

SHOW CREATE TABLE from NEW server is identical to OLD server.

5 added 241 characters in body
source | link

The NEW server doesn't log the error. The only message that it emits is ERROR 3 (HY000): Error writing file '/tmp/MYIZQlbr' (Errcode: 28 - No space left on device) I am not sure I have permission to change the error logging settings...

The NEW server doesn't log the error. The only message that it emits is ERROR 3 (HY000): Error writing file '/tmp/MYIZQlbr' (Errcode: 28 - No space left on device) I am not sure I have permission to change the error logging settings...

4 added 4380 characters in body
source | link

Indicies, OLD server:


Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceDatabase_2_name    1   DB_ID   1   DB_ID   A   146 NULL    NULL    YES BTREE       
ReferenceDatabase_2_name    1   name    1   name    A   97  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceEntity 0   PRIMARY 1   DB_ID   A   737849  NULL    NULL        BTREE       
ReferenceEntity 1   referenceDatabase   1   referenceDatabase   A   90  NULL    NULL    YES BTREE       
ReferenceEntity 1   identifier  1   identifier  A   245949  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
DatabaseObject  0   PRIMARY 1   DB_ID   A   2439461 NULL    NULL        BTREE       
DatabaseObject  1   _class  1   _class  A   65  NULL    NULL    YES BTREE       
DatabaseObject  1   _timestamp  1   _timestamp  A   45175   NULL    NULL        BTREE       
DatabaseObject  1   created 1   created A   187650  NULL    NULL    YES BTREE       
DatabaseObject  1   _displayName    1   _displayName    A   304932  10  NULL    YES BTREE       
DatabaseObject  1   stableIdentifier    1   stableIdentifier    A   2439461 NULL    NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceSequence   0   PRIMARY 1   DB_ID   A   735705  NULL    NULL        BTREE       
ReferenceSequence   1   species 1   species A   52  NULL    NULL    YES BTREE       
ReferenceSequence   1   sequenceLength  1   sequenceLength  A   735705  NULL    NULL    YES BTREE       
ReferenceSequence   1   isSequenceChanged   1   isSequenceChanged   A   735705  10  NULL    YES BTREE       
ReferenceSequence   1   checksum    1   checksum    A   735705  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Species 0   PRIMARY 1   DB_ID   A   79  NULL    NULL        BTREE       
Species 1   abbreviation    1   abbreviation    A   79  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Taxon_2_name    1   DB_ID   1   DB_ID   A   551 NULL    NULL    YES BTREE       
Taxon_2_name    1   name    1   name    A   551 NULL    NULL    YES BTREE       

NEW Server:


Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceDatabase_2_name    1   DB_ID   1   DB_ID   A   146 NULL    NULL    YES BTREE       
ReferenceDatabase_2_name    1   name    1   name    A   97  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceEntity 0   PRIMARY 1   DB_ID   A   737849  NULL    NULL        BTREE       
ReferenceEntity 1   referenceDatabase   1   referenceDatabase   A   90  NULL    NULL    YES BTREE       
ReferenceEntity 1   identifier  1   identifier  A   245950  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
DatabaseObject  0   PRIMARY 1   DB_ID   A   2439461 NULL    NULL        BTREE       
DatabaseObject  1   _class  1   _class  A   65  NULL    NULL    YES BTREE       
DatabaseObject  1   _timestamp  1   _timestamp  A   45175   NULL    NULL        BTREE       
DatabaseObject  1   created 1   created A   187651  NULL    NULL    YES BTREE       
DatabaseObject  1   _displayName    1   _displayName    A   304933  10  NULL    YES BTREE       
DatabaseObject  1   stableIdentifier    1   stableIdentifier    A   2439461 NULL    NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceSequence   0   PRIMARY 1   DB_ID   A   735705  NULL    NULL        BTREE       
ReferenceSequence   1   species 1   species A   52  NULL    NULL    YES BTREE       
ReferenceSequence   1   sequenceLength  1   sequenceLength  A   735705  NULL    NULL    YES BTREE       
ReferenceSequence   1   isSequenceChanged   1   isSequenceChanged   A   735705  10  NULL    YES BTREE       
ReferenceSequence   1   checksum    1   checksum    A   735705  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Species 0   PRIMARY 1   DB_ID   A   79  NULL    NULL        BTREE       
Species 1   abbreviation    1   abbreviation    A   79  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Taxon_2_name    1   DB_ID   1   DB_ID   A   551 NULL    NULL    YES BTREE       
Taxon_2_name    1   name    1   name    A   551 NULL    NULL    YES BTREE       

Indicies, OLD server:


Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceDatabase_2_name    1   DB_ID   1   DB_ID   A   146 NULL    NULL    YES BTREE       
ReferenceDatabase_2_name    1   name    1   name    A   97  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceEntity 0   PRIMARY 1   DB_ID   A   737849  NULL    NULL        BTREE       
ReferenceEntity 1   referenceDatabase   1   referenceDatabase   A   90  NULL    NULL    YES BTREE       
ReferenceEntity 1   identifier  1   identifier  A   245949  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
DatabaseObject  0   PRIMARY 1   DB_ID   A   2439461 NULL    NULL        BTREE       
DatabaseObject  1   _class  1   _class  A   65  NULL    NULL    YES BTREE       
DatabaseObject  1   _timestamp  1   _timestamp  A   45175   NULL    NULL        BTREE       
DatabaseObject  1   created 1   created A   187650  NULL    NULL    YES BTREE       
DatabaseObject  1   _displayName    1   _displayName    A   304932  10  NULL    YES BTREE       
DatabaseObject  1   stableIdentifier    1   stableIdentifier    A   2439461 NULL    NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceSequence   0   PRIMARY 1   DB_ID   A   735705  NULL    NULL        BTREE       
ReferenceSequence   1   species 1   species A   52  NULL    NULL    YES BTREE       
ReferenceSequence   1   sequenceLength  1   sequenceLength  A   735705  NULL    NULL    YES BTREE       
ReferenceSequence   1   isSequenceChanged   1   isSequenceChanged   A   735705  10  NULL    YES BTREE       
ReferenceSequence   1   checksum    1   checksum    A   735705  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Species 0   PRIMARY 1   DB_ID   A   79  NULL    NULL        BTREE       
Species 1   abbreviation    1   abbreviation    A   79  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Taxon_2_name    1   DB_ID   1   DB_ID   A   551 NULL    NULL    YES BTREE       
Taxon_2_name    1   name    1   name    A   551 NULL    NULL    YES BTREE       

NEW Server:


Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceDatabase_2_name    1   DB_ID   1   DB_ID   A   146 NULL    NULL    YES BTREE       
ReferenceDatabase_2_name    1   name    1   name    A   97  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceEntity 0   PRIMARY 1   DB_ID   A   737849  NULL    NULL        BTREE       
ReferenceEntity 1   referenceDatabase   1   referenceDatabase   A   90  NULL    NULL    YES BTREE       
ReferenceEntity 1   identifier  1   identifier  A   245950  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
DatabaseObject  0   PRIMARY 1   DB_ID   A   2439461 NULL    NULL        BTREE       
DatabaseObject  1   _class  1   _class  A   65  NULL    NULL    YES BTREE       
DatabaseObject  1   _timestamp  1   _timestamp  A   45175   NULL    NULL        BTREE       
DatabaseObject  1   created 1   created A   187651  NULL    NULL    YES BTREE       
DatabaseObject  1   _displayName    1   _displayName    A   304933  10  NULL    YES BTREE       
DatabaseObject  1   stableIdentifier    1   stableIdentifier    A   2439461 NULL    NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
ReferenceSequence   0   PRIMARY 1   DB_ID   A   735705  NULL    NULL        BTREE       
ReferenceSequence   1   species 1   species A   52  NULL    NULL    YES BTREE       
ReferenceSequence   1   sequenceLength  1   sequenceLength  A   735705  NULL    NULL    YES BTREE       
ReferenceSequence   1   isSequenceChanged   1   isSequenceChanged   A   735705  10  NULL    YES BTREE       
ReferenceSequence   1   checksum    1   checksum    A   735705  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Species 0   PRIMARY 1   DB_ID   A   79  NULL    NULL        BTREE       
Species 1   abbreviation    1   abbreviation    A   79  10  NULL    YES BTREE       

Table   Non_unique  Key_name    Seq_in_index    Column_name Collation   Cardinality Sub_part    Packed  Null    Index_type  Comment Index_comment
Taxon_2_name    1   DB_ID   1   DB_ID   A   551 NULL    NULL    YES BTREE       
Taxon_2_name    1   name    1   name    A   551 NULL    NULL    YES BTREE       
3 added 83 characters in body
source | link
2 added 140 characters in body
source | link
1
source | link