933008 - Would like production dump of https://quality.mozilla.org/ for/to quality-dev.allizom.org (dev) and quality.allizom.org (staging)

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

If you would, we'd love for a production dump from https://quality.mozilla.org/, on at least https://quality.allizom.org/, and preferably also on https://quality-dev.allizom.org/.

I'm not sure /which/ files, but I'm sure :craigcook could help out with answering that, if there were any questions.

Thanks!

Comment 1

[Craig Cook (:craigcook)]

The only actual *files* we'd need to move would be any uploads attached to blog posts. Otherwise we just need a sanitized DB dump of content and settings, removing or obfuscating user passwords/emails/IPs. It's been done before, we're just way out of date and could use a refresh.

Comment 2

[Stephen Donner [:stephend] Not actively reading bugmail]

:cturra, when you're not busy fighting fires, would you mind taking a look at this?  We'd like to help unblock testing; thanks!

Comment 3

[Daniel Maher [:phrawzty]]

Hello,

Does "any uploads attached to blog posts" mean the contents of "qmo_content/uploads/" (which appears to be composed of image files)?

As for the DB dump: I'm not familiar with your DB structure at all, so any hints you could provide about how to sanitise it would be welcome.

Comment 4

[Stephen Donner [:stephend] Not actively reading bugmail]

(In reply to Daniel Maher [:phrawzty] from comment #3)
> Hello,
> 
> Does "any uploads attached to blog posts" mean the contents of
> "qmo_content/uploads/" (which appears to be composed of image files)?
> 
> As for the DB dump: I'm not familiar with your DB structure at all, so any
> hints you could provide about how to sanitise it would be welcome.

Sorry, as you can see from comment 1, :craigcook is more familiar with that :-)

Comment 5

[Craig Cook (:craigcook)]

(In reply to Daniel Maher [:phrawzty] from comment #3)

> Does "any uploads attached to blog posts" mean the contents of
> "qmo_content/uploads/" (which appears to be composed of image files)?

That's correct. Some posts are undoubtedly embedding images hosted externally but copying the entire uploads folder would cover all the internally hosted images.

Comment 6

[Chris Turra [:cturra]]

sorry about the delay here, but this has finally be done \o/