Changes between Version 26 and Version 27 of ReleaseManagement

Timestamp:

01/27/10 01:43:25 (15 years ago)

Author:

Fran Boon

Comment:

MySQL sync process Prod -> Dev

ReleaseManagement

@@ -18 +18 @@
 
 === Release Process ===
-Overall responsible Person: Fran
+Overall responsible Person: Fran (currently)
 
  1. Where generic, new code is merged 1st into Trunk by Fran
@@ -24 +24 @@
   * RMS is currently Haiti-specific so is merged directly to Haiti branch
  3. Code is pulled from the Haiti branch to Dev by Fran
-  * Data is 1st synced from Prod (''tbc'')
+  * Data is 1st synced from Prod:
+{{{
+/root/automysqlbackup.sh
+scp /backups/daily/haitiprod/haitiprod_2010-01-27_01h24m.Wednesday.sql.gz flavour@haiti-dev.sahanafoundation.org:.
+
+gunzip haitiprod_2010-01-27_01h24m.Wednesday.sql.gz
+sed 's/haitiprod/haitidev/g' haitiprod_2010-01-27_01h24m.Wednesday.sql > haitidev_import.sql
+vim /etc/crontab
+#0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
+ln -sf /etc/apache2/sites-available/dev-maintain /etc/apache2/sites-enabled/dev
+/etc/init.d/apache2 force-reload
+mysql
+drop DATABASE haitidev;
+\q
+mysql < haitidev_import.sql
+}}}
   * A 1st draft of a data migration plan is made
  4. Code is pulled from the Haiti branch to UAT by lifeeth or chamindra