Changes between Version 18 and Version 19 of SopUpdateBbmriApp

Timestamp:

2013-05-29T12:15:54+02:00 (11 years ago)

Author:

Roan Kanninga

Comment:

--

SopUpdateBbmriApp

@@ -35 +35 @@
    * You are now at /srv/molgenis/ where your files where copied.
 
-=== Backup  ===
+=== Backup ===
  1. '''BACKUP your DATABASE FIRST''':
    * mysqldump bbmri -u molgenis –pmolgenis  > ~/databaseDumps/<date>bbmriDB.mysql
    * Check the dumbed file if it is not just an error file …
 
-=== Insert the data from live server to test server  ===
-===  * mysql -u molgenis -pmolgenis bbmri < 29Maydump.mysql     
-
- ===
+=== Insert the data from live server to test server ===
+=== * mysql -u molgenis -pmolgenis bbmri < 29Maydump.mysql ===
+  ===
+
  * Apply migration steps:
    * mysql -u molgenis –pmolgenis
@@ -93 +93 @@
   ALTER TABLE !`BiobankSubCategory` 
   ADD CONSTRAINT !`biobank_ibfk_5`
-      FOREIGN KEY (!`id`) REFERENCES !OntologyTerm (id) ON DELETE CASCADE; AUTO UPARXEI HDH APO THN DHMIOURGIA TOU)
+      FOREIGN KEY (!`id`) REFERENCES !OntologyTerm (id) ON DELETE CASCADE; this exists already from his creation)
    
   ALTER TABLE Biobank ADD FOREIGN KEY (!SubCategory) REFERENCES !BiobankSubCategory (id) ON DELETE RESTRICT;