Changes between Version 24 and Version 25 of SopUpdateBbmriApp

Timestamp:

2013-05-29T13:51:03+02:00 (12 years ago)

Author:

antonak

Comment:

--

SopUpdateBbmriApp

@@ -21 +21 @@
    1. Ask credentials for molgenis35/molgenis14 from Pieter or Morris.
 
-=== create migration script  ===
- 1. If you know the exact changes of the database, compared to the old version in live server, then the migration script is the commands that synchornize the two versions. 
- 1. You can compare the mysql dump files between the live and the local version. This is easier if you dump only the schemas (not the data) . 
-   1. This is done: mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDB.mysql
+=== create migration script ===
+ 1. If you know the exact changes of the database, compared to the old version in live server, then the migration script is the commands that synchornize the two versions.
+ 1. You can compare the mysql dump files between the live and the local version. This is easier if you dump only the schemas (not the data) .
+   1. First ssh to molgenis14
+   1. create a dump file: mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDBlive.mysql
+   1. create a local dump file:  mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDBlocal.mysql
+   1. diff <date>bbmriDBlive.mysql <date>bbmriDBlocal.mysql
 
 === copy war file & migration script from your  computer to test server ===
@@ -35 +38 @@
    * ssh  !molgenis@molgenis14.target.rug.nl
  1. Get data:
-   * mysqldump bbmri -u molgenis –pmolgenis  > ~/databaseDumps/<date>bbmriDB.mysql
+   * mysqldump bbmri -u molgenis –p > ~/databaseDumps/<date>bbmriDB.mysql
 
 === Copy data from LIVE server to your computer ===