569840 - Need a database dump of live drumbeat drupal database

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Paul Osman [:paulosman]]

Need a gziped database dump of the production MySQL database for drumbeat.org. Should be called 'mozcrm_drupal'. You can drop the file in /root on drumbeat.stage.mozilla.com and I can grab it from there.

Unfortunately, because Drupal couples data and code changes, and because drumbeat.org currently has no way of tracking database changes, we'll probably need this to happen from time to time. Is there a way to automate it to happen on a semi-regular basis? Alternatively, is it possible for me to get some kind of access to the production server so that I can do it myself?

Comment 1

[Paul Osman [:paulosman]]

Escalating somewhat. Not having this is holding us up from being able to set up / restore a proper staging environment.

Comment 2

[chizu]

Pushed drumbeat_org_civicrm.2010.06.09.sql.gz over to drumbeat.stage.

Could just do that on a weekly or monthly cron to automate it. Would that work?

Comment 3

[Paul Osman [:paulosman]]

Awesome, thanks. Weekly cron would be great (save me from having to create a ticket and bugging you guys).

Comment 4

[Paul Osman [:paulosman]]

Sorry have to reopen, that seems to be a dump of the 'mozcrm_civicrm' database. I need the 'mozcrm_drupal' database.

Comment 5

[chizu]

Oops, I had copied drumbeat_org_drupal.2010.06.09.sql.gz over too and deleted the wrong one.

Comment 6

[Paul Osman [:paulosman]]

Need this again. Just a recent copy of the mozcrm_drupal database. If you could gzip it and move it to /root/ on drumbeat.stage.mozilla.com, that would be appreciated.

Comment 7

[Dave Miller [:justdave]]

I'll take care of this shortly... in the future it'd be appreciated if you could open a new bug for these instead of reopening an old one (feel free to use the "Clone This Bug" link at the bottom to save yourself all the typing though).

Comment 8

[Paul Osman [:paulosman]]

Sure thing. I wasn't sure if I should open a new one, or just reopen, so that's good to know. Thanks Dave!

Comment 9

[Paul Osman [:paulosman]]

Any idea of when this might be done? It's currently blocking a ticket of mine and I'd like to give the reporter of that one an estimate. Thanks.

Comment 10

[Paul Osman [:paulosman]]

Have to upgrade to critical. This is preventing engagement from sending out a critical newsletter update for fund raising and is holding me back from getting a new volunteer up and running with a current version of the site.

Comment 11

[Dave Miller [:justdave]]

Done. Sorry for the delay.  drumbeat_org_sql_20100825.tar.gz has been dropped in /root on drumbeat.stage.mozilla.com.