567382 - Resync support-stage and support-stage-new databases

Status: RESOLVED FIXED

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

Description

[James Socol [:jsocol, :james]]

In yesterday's push, we fixed a schema issue with SUMO. We should update both stage servers with an up-to-date copy of the production database.

Comment 1

[James Socol [:jsocol, :james]]

But before wiping out support-stage-new, could you please dump the forums_post table and save a copy for us?

Comment 2

[timellis]

I am just now getting around to looking at this. Questions:

(1) Where should I put the forums_post dump?
(2) Do you want it in SQL Format or just a tab-separated values table?

For my own notes, I also need to do this:

"""
whoever updates support-stage and support-stage-new's DB from prod, please run truncate tiki_user_watches so real users don't get emails for stage!

Further info : https://intranet.mozilla.org/Support-stage.mozilla.org#Syncing_the_production_DB_to_stage
"""

Comment 3

[James Socol [:jsocol, :james]]

(1) We figured out the issue there, we can probably skip that.
(2) See 1.

Hopefully I stalled long enough: can we do this tomorrow (Tuesday) morning?

Comment 4

[timellis]

I'm doing it now. I would like to give a time estimate, but the dump file is huge (many hundreds of megabytes) which I didn't expect. It may take most of the day to restore it.

Comment 5

[timellis]

This should be done. I only did support_stage_new_mozilla_com per conversation in IRC. Let me know if you want more. I have dumps. Am able to apply to DBs.