Jump to content

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.