599115 - Sync stage database from prod and run some SQL

Status: VERIFIED FIXED

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

Description

[Paul Craciunoiu [:paulc]]

We need to run some SQL from bug 592776, and that would be best tested against a latest copy of the production database.

Steps:
1. Import prod db to staging server (http://support-stage.mozilla.com)
2. Run this SQL and paste the output here please:
---
UPDATE questions_question SET creator_id = creator_id + 643 WHERE creator_id <=
208568 and creator_id >= 208553;
UPDATE questions_answer SET creator_id = creator_id + 643 WHERE creator_id <=
208568 and creator_id >= 208553;
---


Thanks! Let me know if anything is unclear.

Comment 1

[Paul Craciunoiu [:paulc]]

Could we get some movement on this please?

Comment 2

[Dave Miller [:justdave]]

Restore in progress.  notifications_eventwatch and tiki_user_watches will be truncated as soon as the restore completes.

Comment 3

[Dave Miller [:justdave]]

mysql> UPDATE questions_question SET creator_id = creator_id + 643 WHERE creator_id <=
    -> 208568 and creator_id >= 208553;
Query OK, 13 rows affected (1.00 sec)
Rows matched: 13  Changed: 13  Warnings: 0

mysql> UPDATE questions_answer SET creator_id = creator_id + 643 WHERE creator_id <=
    -> 208568 and creator_id >= 208553;
Query OK, 35 rows affected (0.08 sec)
Rows matched: 35  Changed: 35  Warnings: 0

Comment 4

[Paul Craciunoiu [:paulc]]

Awesome. Thanks justdave! I'll leave it to QA to verify bug 592776 on stage.