Changes between Version 9 and Version 10 of DespoinaLog/2010/12/08

Timestamp:

2010-12-08T14:23:02+01:00 (15 years ago)

Author:

antonak

Comment:

--

DespoinaLog/2010/12/08

@@ -31 +31 @@
    * '''SOLUTION'''
      * mysql> alter table bbmri_old.!OntologyTerm change term name varchar(255) ;
-     * Query OK, 164 rows affected (0.32 sec)
-     * Records: 164  Duplicates: 0  Warnings: 0
-     * * mysql> alter table bbmri_old.!OntologyTerm add column !__Type enum('!OntologyTerm','Species')  ;
-     * Query OK, 164 rows affected (0.11 sec)
-     * Records: 164  Duplicates: 0  Warnings: 0
-     *      * mysql> alter table bbmri_old.!OntologyTerm add column termPath varchar(1024);
-     * 
+     * mysql> alter table bbmri_old.!OntologyTerm add column !__Type enum('!OntologyTerm','Species')  ;
+     * mysql> alter table bbmri_old.!OntologyTerm add column termPath varchar(1024);
+     * mysqldump5 -u root -p bbmri_old ontologyTerm > ontologyTerm.mysql
+     * mysql5 -u root -p bbmri < ontologyTerm.mysql
    * 
  * * mysql> describe biobanks;