978551 - Please make another public database extract

Status: RESOLVED FIXED

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

Description

[Kyle Lahnakoski [:ekyle]]

There has been many schema changes since the last extract.  I would like to test the BZ-ETL with the data found in this new schema.

http://people.mozilla.org/~mhoye/bugzilla/

Thank you

Comment 1

[David Lawrence [:dkl]]

DBA, please create a new sanitized dump of the production BMO database and place in a location easily accessed.

Thanks
dkl

Comment 2

[Sheeri Cabral [:sheeri]]

Will do now, sorry, the bugzilla crisis last week used lots of cycles and Friday was a catch-up day.

Comment 3

[Sheeri Cabral [:sheeri]]

For my info, running:
cd /data/www/bugzilla.mozilla.org/ ; /data/backups/bin/sanitize.sh -s contrib/sanitizeme.pl -i bugzilla -o oneoff -d bugs

If this works as planned, we can script that to run monthly, like the other sanitizations.

Comment 4

[Sheeri Cabral [:sheeri]]

The public database extract is on Google drive at:
https://drive.google.com/a/mozilla.com/file/d/0B_GP1OghOtJSS3gwemZodVItd3c/edit?usp=sharing

I've shared with mhoye, dkl, and ekyle.

Comment 5

[Kyle Lahnakoski [:ekyle]]

Do you have a checksum for that from the original file?  I get burned with files this big.

Thanks

Comment 6

[Sheeri Cabral [:sheeri]]

[[e-mail]3 oneoff]# md5sum  2014.03.16.sanitized.oneoff.sql.gz 
2b91fa0e85025bc76667e498e124d62d  2014.03.16.sanitized.oneoff.sql.gz