868356 - TBPL production DB dump of 'runs', 'runs_notes' & 'builders' tables

Status: RESOLVED FIXED

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

Description

[David Burns :automatedtester]

Please can I have a dump of the data from tbpl, up to 2 months worth of data if possible, without the run_logs table so I can do some analysis on the data.

Thanks!

Comment 1

[Ed Morley [:emorley]]

TBPL was last purged 2013-03-18 (bug 779290, keeps just the last 30 days worth), so there should be job results from ~2013-02-18 onwards in there. Looking at bug 779290 comment 31, it may not be necessary to specify a time range (presuming that makes things simpler for sheeri) since total size should be no more than a couple of GB for the tables you need.

Needed tables:
runs
runs_notes
builders

Comment 2

[Ed Morley [:emorley]]

Sorry, meant to add that the TBPL data is non confidential, so I'm fine with this being uploaded to ftp/people/...

Comment 3

[Sheeri Cabral [:sheeri]]

Ed, thanks for that information, it's very helpful. We've actually been working on a monthlyl automated purge system to happen monthly, and it was supposed to run for the first time this week, so I can't promise 2 months, but at this point any purges have been put on hold until I do this export. Just an FYI.

Comment 4

[Ed Morley [:emorley]]

No worries if we only get 30 days, the purges are necessary after all :-)

Comment 5

[Ed Morley [:emorley]]

(And ordinarily we wouldn't need more than 30 days anyway)

Comment 6

[Sheeri Cabral [:sheeri]]

exporting now....

Comment 7

[Sheeri Cabral [:sheeri]]

David - please download the compressed sql file at:

http://people.mozilla.com/~scabral/2013_05_03_bug868356.sql.gz

It contains the mysql tables and data for the runs, runs_notes and builders tables.