Changes between Version 3 and Version 4 of DespoinaLog/2010/12/09


Ignore:
Timestamp:
2010-12-09T11:01:25+01:00 (14 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DespoinaLog/2010/12/09

    v3 v4  
    66 * create new table biobank from pheno project as follows:
    77
     8  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate , Description, id from biobank ;
    89
    9 
    10         mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate, Description, id from biobank ;
    11 
    12         (only fields that exist in biobank in gcc project)
     10  (only fields that exist in biobank in gcc project)
    1311
    1412 * Dump and insert new table in gcc project.
    15    * $ mysqldump5 -u root -p bbmri_old biobank_new > biobank_new.mysql 
     13   * $ mysqldump5 -u root -p bbmri_old biobank_new > biobank_new.mysql
     14 * Edit  biobank_new.mysql and replace biobank_new (table) with biobank
     15 *
    1616   * mysql5 -u root -p bbmri < biobank_new.mysql
    17  * Edit