Changes between Version 14 and Version 15 of SopUpdateBbmriApp

Timestamp:

2013-05-29T11:43:53+02:00 (11 years ago)

Author:

antonak

Comment:

--

SopUpdateBbmriApp

@@ -10 +10 @@
  1. As also listed here: http://www.molgenis.org/wiki/MolgenisServers the '''test server''' is at molgenis35(https://molgenis35.target.rug.nl/biobanks/) and the '''production server''' at molgenis14(https://catalogue.bbmri.nl/biobanks/) .
  1. First deploy at test server, notify [mailto:david.van.enckevort@nbic.nl david.van.enckevort AT nbic.nl]. He will notify BBMRI office, they will review the changes and if everything is ok proceed to updating bbmri production server.
- 1. Deploy at at server: molgenis35 (Take a look here also http://www.molgenis.org/wiki/SopCreateMolgenisVM#SopDeploymentForDevs ) :
+ 1. Deploy at test server: molgenis35 (Take a look here also http://www.molgenis.org/wiki/SopCreateMolgenisVM#SopDeploymentForDevs ) :
    1. Ask credentials for molgenis35/molgenis14 from Pieter or Morris.
-   1. Copy the war file and the mysql migration script to the server as follows:
-     1. scp  <filename>.war !molgenis@molgenis35.target.rug.nl:./ 
-   1. Ssh to the server:
-     * ssh  !molgenis@molgenis14.target.rug.nl
-     * You are now at /srv/molgenis/ where your files where copied.
-     * The database is bbmri, so in order to apply the migration steps you created:
-     * '''BACKUP your DATABASE FIRST''':
-       * mysqldump bbmri -u molgenis –pmolgenis  > ~/databaseDumps/<date>bbmriDB.mysql
+
+===war file & migration script from your  computer ===
+
+ 1. Copy the war file and the mysql migration script  from your computer  to the server as follows:
+   1. scp  <filename>.war !molgenis@molgenis35.target.rug.nl:./
+
+===Export data from LIVE server ===
+
+ 1. Ssh to the server:
+   * ssh  !molgenis@molgenis14.target.rug.nl
+ 1. Get data: 
+   * mysqldump bbmri -u molgenis –pmolgenis  > ~/databaseDumps/<date>bbmriDB.mysql
+
+===copy data from LIVE server to your computer ===
+
+ 1. scp  molgenis@molgenis14.target.rug.nl:./databaseDumps/<date>bbmriDB.mysql  ./mysql<date>LIVEdata.mysql
+
+===copy data from your computer to test server ===
+
+ 1. scp   ./mysql<date>LIVEdata.mysql molgenis@molgenis35.target.rug.nl:./databaseDumps/mysql<date>LIVEdata.mysql
+
+===Deploy at test server===
+
+ 1. Ssh to the server:
+   * ssh  !molgenis@molgenis35.target.rug.nl
+   * You are now at /srv/molgenis/ where your files where copied.
+   * The database is bbmri, so in order to apply the migration steps you created:
+   * '''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 …
@@ -37 +58 @@
    * sudo service mysqld status
 
- * Check your deployment at: [https://molgenis35.target.rug.nl/biobanks/ https://molgenis35.target.rug.nl/biobanks/]
+ * Check your deployment at: https://molgenis35.target.rug.nl/biobanks/
 
 == ''' The same steps apply to the production server molgenis14 . ''' ==