Changes between Version 15 and Version 16 of DespoinaLog/2010/12/08
- Timestamp:
- 2010-12-08T15:01:39+01:00 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DespoinaLog/2010/12/08
v15 v16 2 2 * [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 3 3 4 == Inconsistency with !OntologyTerm table 4 == Inconsistency with !OntologyTerm table == 5 5 * org.molgenis.framework.db.!DatabaseException: Unknown column '!OntologyTerm.!__Type' in 'where clause' 6 6 * Was this produced after the import ? (generate gcc, update db -> test if it is shown --> import -> test if it's there) … … 41 41 === '''mysql> update !OntologyTerm set !__Type="!OntologyTerm"''' === 42 42 === '''problem solved ! ''' === 43 == Inconsistency with Biobanks table 44 * mysql> describe biobanks;43 == Inconsistency with Biobanks table == 44 * mysql> describe biobanks; 45 45 46 46 * ERROR 1146 (42S02): Table 'bbmri.biobanks' doesn't exist … … 73 73 74 74 === But according to the model this is the complete list of fields : === 75 === * id 76 * name 77 * Investigation 78 * ontologyReference 79 * Individuals 80 * Species 81 * PanelType 82 * FounderPanels 83 * Acronym 84 * Institutes 85 * Publications 86 * Category 87 * Type 88 * Contacts 89 * Topics 90 * Materials 91 * Size 92 * LastUpdate 93 * Description 94 95 === 75 === === 76 * id 77 * name 78 * Investigation 79 * ontologyReference 80 * Individuals 81 * Species 82 * PanelType 83 * FounderPanels 84 * Acronym 85 * Institutes 86 * Publications 87 * Category 88 * Type 89 * Contacts 90 * Topics 91 * Materials 92 * Size 93 * LastUpdate 94 * Description
