Production to staging sync
Local installations of Flow Production Tracking are no longer offered. This documentation is intended only for those with existing instances of Flow Production Tracking Enterprise Docker. Click here for a list of our current offerings.
This articles explains how to sync the production data to the staging site.
This is intended for Flow Production Tracking System Administrators.
Backup production site
Do a backup of your production database using Flow Production Tracking Enterprise (SE) for Docker or the Database backup operation. You’ll probably want to exclude events from that backup.
Copy backup to staging cluster
Here is an example of how to copy the backup folder from production to staging on the same server.
# Copy from production dbops container to current folder.
docker cp simple_dbops_1:/db_backup/shotgun-v_unknown-20170825T121731Z .
# Copy from current folder to staging dbops container.
docker cp shotgun-v_unknown-20170825T121731Z/ staging_dbops_1:/db_backup/ Here is an example of how to use rsync to copy the backup folder from production to staging on different servers.
rsync -av -e "ssh" shotgun-prod-server:/opt/shotgun/se/production/db_backup/shotgun-v_unknown-20170825T121731Z /opt/shotgun/se/staging/db_backup/ Restore production backup in staging
Restore production backup in the staging database using SE for Docker, or see the Database restore operation.