Database Downsync (i.e Prod to Uat)
- Open WebOps and check the backups.
- Open
IDEand check if Green or Blue active - Open WebOps UI and select export backup
- You can check the exporting process in Jenkins
- Once backed, select the manual backup in WebOps and download it to your local
- Open Mysql workbench
- Go to Administration tab
- Select import/restore
- Select import-from-self-contained file
- Choose the DB backup you downloaded
- Select the target schema(the DB you want to sync)
- Select import
- Go to WebOps website url and check if the pages work properly(to confirm the process)
This scenario works if you work with WebOps. If working with other tools, just follow the same steps with the DB backup tool you have.