update snapshot

# All workflows
mysqldump  --single-transaction --opt  crm_zeald \
 --tables  workflow_activities workflow_activity_actions workflow_activity_roles workflow_checklists  \
            workflow_processes workflow_roadmap_supercedes workflow_roles  workflow_task_savesearch workflow_transitions \
           workflow_user_roles  workflow_instances workflow_instance_activities | gzip | gzip -d | mysql -u zeald -p -h zdbi-extranet-staging1-aws-az1-1.cjhfgycqq4qs.ap-southeast-2.rds.amazonaws.com crm_zeald_snapshot

# All products & Subscriptions
mysqldump  --single-transaction --opt  crm_zeald \
 --tables  products prices products_groups products_job_codes services service_types | gzip  | gzip -d | mysql -u zeald -p -h zdbi-extranet-staging1-aws-az1-1.cjhfgycqq4qs.ap-southeast-2.rds.amazonaws.com crm_zeald_snapshot

# Recently created accounts, projects, jobs
mysqldump  --single-transaction --no-create-db --no-create-info --replace --opt crm_zeald \
 --tables accounts projects jobs --where 'date_entered > NOW() - INTERVAL 2 MONTH OR date_modified > NOW() - INTERVAL 2 MONTH' \
 | gzip | gzip -d | mysql -u zeald -p -h zdbi-extranet-staging1-aws-az1-1.cjhfgycqq4qs.ap-southeast-2.rds.amazonaws.com crm_zeald_snapshot

# Recently created meetings, calls, tasks
mysqldump --single-transaction --no-create-db --no-create-info --replace --opt  crm_zeald \
 --tables meetings calls tasks --where 'date_entered > NOW() - INTERVAL 2 MONTH OR date_modified > NOW() - INTERVAL 2 MONTH' \
 | gzip  | gzip -d | mysql -u zeald -p -h zdbi-extranet-staging1-aws-az1-1.cjhfgycqq4qs.ap-southeast-2.rds.amazonaws.com crm_zeald_snapshot

# GEM tags
mysqldump --no-create-db --no-create-info --replace --opt  crm_zeald \
 --tables tags --where \"tag LIKE 'GEM%'\" \
 | gzip  | gzip -d | mysql -u zeald -p -h zdbi-extranet-staging1-aws-az1-1.cjhfgycqq4qs.ap-southeast-2.rds.amazonaws.com crm_zeald_snapshot