* When importing bbmri mysql table , table structures change --> exception . * [http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Try to export / import one table at a time] : mysqldump5 -u root -p bbmri biobank >biobank.mysql / mysqldump5 -u root -p bbmri_old biobank >biobank.mysql / mysql5 -u root -p bbmri < biobank.mysql / mysql5 -u root -p bbmri < ontologyTerm.mysql * org.molgenis.framework.db.!DatabaseException: Unknown column '!OntologyTerm.!__Type' in 'where clause' * Was this produced after the import ? (generate gcc, update db -> test if it is shown --> import -> test if it's there) * So this is the problem for !OntologyTerm : * * mysql> describe !OntologyTerm; * +---------------+--------------------------------+------+-----+---------+----------------+ * | Field | Type | Null | Key | Default | Extra | * +---------------+--------------------------------+------+-----+---------+----------------+ * | id | int(11) | NO | PRI | NULL | auto_increment | * | name | varchar(127) | NO | | NULL | | * | !__Type | enum('!OntologyTerm','Species') | NO | | NULL | | * | ontology | int(11) | YES | MUL | NULL | | * | termAccession | varchar(255) | YES | | NULL | | * | definition | varchar(255) | YES | | NULL | | * | termPath | varchar(1024) | YES | | NULL | | * +---------------+--------------------------------+------+-----+---------+----------------+ * 7 rows in set (0.04 sec) * * mysql> describe bbmri_old.!OntologyTerm; * +---------------+--------------+------+-----+---------+----------------+ * | Field | Type | Null | Key | Default | Extra | * +---------------+--------------+------+-----+---------+----------------+ * | id | int(11) | NO | PRI | NULL | auto_increment | * | term | varchar(255) | NO | | NULL | | * | ontology | int(11) | YES | MUL | NULL | | * | termAccession | varchar(255) | YES | | NULL | | * | definition | varchar(255) | YES | | NULL | | * +---------------+--------------+------+-----+---------+----------------+ * 5 rows in set (0.01 sec)  * * mysql> describe biobanks; * ERROR 1146 (42S02): Table 'bbmri.biobanks' doesn't exist * mysql> describe biobank; * +-------------+--------------------------------+------+-----+---------+-------+ * | Field       | Type                           | Null | Key | Default | Extra | * +-------------+--------------------------------+------+-----+---------+-------+ * | Acronym     | varchar(255)                   | YES  |     | NULL    |       | * | Category    | int(11)                        | NO   | MUL | NULL    |       | * | Type        | enum('core','support','other') | NO   |     | NULL    |       | * | Size        | varchar(255)                   | YES  |     | NULL    |       | * | !LastUpdate  | date                           | NO   |     | NULL    |       | * | Description | text                           | YES  |     | NULL    |       | * | id          | int(11)                        | NO   | PRI | NULL    |       | * +-------------+--------------------------------+------+-----+---------+-------+ * 7 rows in set (0.00 sec) * * mysql> describe bbmri_old.biobank; * +-------------+--------------------------------+------+-----+---------+-------+ * | Field       | Type                           | Null | Key | Default | Extra | * +-------------+--------------------------------+------+-----+---------+-------+ * | Acronym     | varchar(255)                   | YES  |     | NULL    |       | * | Category    | int(11)                        | NO   | MUL | NULL    |       | * | Type        | enum('core','support','other') | NO   |     | NULL    |       | * | Size        | varchar(255)                   | YES  |     | NULL    |       | * | !LastUpdate  | date                           | NO   |     | NULL    |       | * | Description | text                           | YES  |     | NULL    |       | * | id          | int(11)                        | NO   | PRI | NULL    |       | * +-------------+--------------------------------+------+-----+---------+-------+ * 7 rows in set (0.00 sec) *