Changes between Version 29 and Version 30 of SopUpdateBbmriApp


Ignore:
Timestamp:
2013-05-29T14:03:02+02:00 (12 years ago)
Author:
antonak
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • SopUpdateBbmriApp

    v29 v30  
    1010
    1111= Detailed tutorial =
    12 = 1. Export war & mysql file locally  =
     12= 1. Export war & mysql file locally =
    1313== 1.1 Run the app on your molgenis-legacy workspace (using tomcat, not standalone) ==
    1414 1. Export the war file
    … …  
    2525 1. If you know the exact changes of the database, compared to the old version in live server, then the migration script is consisted of the commands that synchornize the two versions.
    2626 1. You do not know, you can 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) .
    27    1. First ssh to molgenis14
    28    1. create a dump file: mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDBlive.mysql
     27   1. First ssh to molgenis14, create file & copy it 
     28     1. ssh molgenis@molgenis14.target.rug.nl
     29     1. create a dump file: mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDBlive.mysql
     30     1. LOCALLY : scp molgenis@molgenis14.target.rug.nl:./databaseDumps/<date>bbmriDB.mysql ./mysql<date>LIVEdata.mysql
    2931   1. create a local dump file:  mysqldump --no-data, -d bbmri -u molgenis –pmolgenis > ~/databaseDumps/<date>bbmriDBlocal.mysql
    3032   1. diff <date>bbmriDBlive.mysql <date>bbmriDBlocal.mysql
    3133
    32 === 2.2 copy war file & migration script from your  computer to test server ===
     34=== 2.2 copy war file & migration script from your  computer to test server ===
    3335 1. Copy the war file and the mysql migration script  from your computer  to the server as follows:
    3436   1. scp  <filename>.war molgenis@molgenis35.target.rug.nl:./
    … …  
    3638
    3739=== 2.3 Export data from LIVE server ===
    38  1. Ssh to the server:
    39    * ssh  !molgenis@molgenis14.target.rug.nl
    40  1. Get data:
    41    * mysqldump bbmri -u molgenis –p > ~/databaseDumps/<date>bbmriDB.mysql
    42 
    43 === 2.4 Copy data from LIVE server to your computer ===
    44  1. scp  molgenis@molgenis14.target.rug.nl:./databaseDumps/<date>bbmriDB.mysql  ./mysql<date>LIVEdata.mysql
    45 
    46 === 2.5 Copy data from your computer to test server ===
     40=== 2.5 Copy data from your computer to test server ===
    4741 1. scp   ./mysql<date>LIVEdata.mysql molgenis@molgenis35.target.rug.nl:./databaseDumps/mysql<date>LIVEdata.mysql
    4842
    49 === 2.6 Deploy at test server ===
     43=== 2.6 Deploy at test server ===
    5044 1. Ssh to the server:
    5145   * ssh  !molgenis@molgenis35.target.rug.nl
    5246   * You are now at /srv/molgenis/ where your files where copied.
    5347
    54 === 2.7 Backup ===
     48=== 2.7 Backup ===
    5549 1. '''BACKUP your DATABASE FIRST''':
    5650   * mysqldump bbmri -u molgenis –pmolgenis  > ~/databaseDumps/<date>bbmriDB.mysql