1903798 - Please provide sanitized dump of BMO database for use by contractor for upcoming work

Status: RESOLVED FIXED

(Cloud Services :: Operations: Bugzilla, task)

Description

[David Lawrence [:dkl]]

We need an up to date sanitized dump of the BMO database to provide for work being done by contractor. Here is a high level process we have done in the past but may need to be altered to work for GCP.

1. Export current production BMO database from snapshot, etc.
2. Create temporary DB and then import the dump.
3. On a container with BMO code such as a webhead, run the sanitizeme.pl script against the running snapshot.
4. Export the sanitized DB to a SQL file that can be uploaded to google drive.
5. Remove container and temporary database.

Let me know if there is anything I missed or that I can help with.

dkl

Comment 1

[David Lawrence [:dkl]]

Ping on the status of this request

Comment 2

[Eric Maydeck]

This has been completed. You can find the dump in a GCS bucket in the nonprod project. I sent you the exact location in our other thread.

Comment 3

[David Lawrence [:dkl]]

(In reply to Eric Maydeck from comment #2)

This has been completed. You can find the dump in a GCS bucket in the nonprod project. I sent you the exact location in our other thread.

Thanks Eric. I will check this out locally to make sure there is nothing more we need to remove and zip it up for delivery.

Comment 4

[David Lawrence [:dkl]]

This is now complete. Closing.