Changes between Version 3 and Version 4 of DespoinaLog/2010/12/09
- Timestamp:
- 2010-12-09T11:01:25+01:00 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DespoinaLog/2010/12/09
v3 v4 6 6 * create new table biobank from pheno project as follows: 7 7 8 mysql> create table biobank_new select Acronym, Category, Type, Size, !LastUpdate , Description, id from biobank ; 8 9 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) 13 11 14 12 * 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 * 16 16 * mysql5 -u root -p bbmri < biobank_new.mysql 17 * Edit