944038 - Need more recent sanitized db dump to use as sample data for BMO developer box

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[David Lawrence [:dkl]]

Currently the latest is early october on Mhoyes's people page which is pre tracking flag migration. Would be nice to have a more recent sanitized dump work with to include in the developer box vagrant image.

Thanks
dkl

Comment 1

[Mike Hoye [:mhoye]]

We've cued it up to run once a quarter, but Sheeri can presumably pull the trigger on the sanitization script whenever. Sheeri, needinfo chooses you!

Comment 2

[Sheeri Cabral [:sheeri]]

Can I get you this on Monday?

Comment 3

[David Lawrence [:dkl]]

(In reply to Mike Hoye [:mhoye] from comment #1)
> We've cued it up to run once a quarter, but Sheeri can presumably pull the
> trigger on the sanitization script whenever. Sheeri, needinfo chooses you!

If it was just a week or so away, I could easily wait. But if Sheeri has the time next week then that will help me sooner.

(In reply to Sheeri Cabral [:sheeri] from comment #2)
> Can I get you this on Monday?

Monday is fine. I will be in SF all next week.

Thanks
dkl

Comment 4

[Sheeri Cabral [:sheeri]]

Sanitizing the 12/1 export now...

Comment 5

[Sheeri Cabral [:sheeri]]

sanitization is now being uploaded to the google shared drive. I'll let you know when the upload is complete.

The md5 sum is 3066378712835e7aab8b2e8852aebba9  sanitized_bugzilla_2013_12_02.sql.gz

Comment 6

[Sheeri Cabral [:sheeri]]

File has finished uploading to our shared drive at: https://drive.google.com/a/mozilla.com/?usp=folder#folders/0B_GP1OghOtJSNkRtb2p3eXN0ZW8

Do you think you will want monthly sanitized exports, instead of quarterly?

Comment 7

[David Lawrence [:dkl]]

(In reply to Sheeri Cabral [:sheeri] from comment #6)
> File has finished uploading to our shared drive at:
> https://drive.google.com/a/mozilla.com/?usp=folder#folders/
> 0B_GP1OghOtJSNkRtb2p3eXN0ZW8
> 
> Do you think you will want monthly sanitized exports, instead of quarterly?

Unable to access folder with ID: 0B_GP1OghOtJSNkRtb2p3eXN0ZW8. Check access permissions on the folder.

dkl

Comment 8

[Sheeri Cabral [:sheeri]]

Added :glob and :dkl to the shared folder.

Comment 9

[David Lawrence [:dkl]]

(In reply to Sheeri Cabral [:sheeri] from comment #6)
> Do you think you will want monthly sanitized exports, instead of quarterly?

I still think quarterly will be sufficient. I do not wish to update the DeveloperBox more often than that anyway so I am good with quarterly.

dkl