Fundraising/techops/procedures/services-civicrm staging db refresh

From Wikitech

Every quarter or so, we will want to refresh the staging databases. To do so we use the following steps:

  1. Pull the latest database backups for the civicrm, drupal, and fredge databases from frlog1002 to the current frdb_staging host placing them in the /srv/db_restore directory.
  2. cd /srv/db_restore
  3. Run /usr/local/bin/staging_db_refresh in a screen session answering the prompts.
  4. Monitor the output of the log file. It will take approximately 3 days to complete the selective restore as of 2023-11-16.
Retrieved from "https://wikitech.wikimedia.org/w/index.php?title=Fundraising/techops/procedures/services-civicrm_staging_db_refresh&oldid=2127731"