Changes between Version 26 and Version 27 of ReleaseManagement


Ignore:
Timestamp:
01/27/10 01:43:25 (12 years ago)
Author:
Fran Boon
Comment:

MySQL sync process Prod -> Dev

Legend:

Unmodified
Added
Removed
Modified
  • ReleaseManagement

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