549713 - Open to choice: import prod DB on stage

Status: RESOLVED FIXED

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

Description

[Alex Buchanan [:abuchanan]]

Hey,

We need a DB import for opentochoice2.stage.m.c

Marking high priority, because Stas and Mary say they need this asap.

Please import the production DB.  You'll need to run this SQL manually, to fix Wordpress keeping it's base URL in the DB.


Update wp_options set option_value = 'http://opentochoice2.stage.mozilla.com' where option_name = 'siteurl';

Update wp_options set option_value = 'http://opentochoice2.stage.mozilla.com' where option_name = 'home';


Thanks!

(Sorry we have all this busy work for Open to Choice.  Wordpress makes it difficult to release milestones as we usually do.  Today should be the last day of this stuff)

Comment 1

[chizu]

Production dump imported.

mysql> Update wp_options set option_value = 'http://opentochoice2.stage.mozilla.com'
    -> where option_name = 'siteurl';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> Update wp_options set option_value = 'http://opentochoice2.stage.mozilla.com'
    -> where option_name = 'home';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Comment 2

[Alex Buchanan [:abuchanan]]

I'm guessing you used a DB backup from this morning (> 12 hours ago)

Stas would like a fresh dump from production, since a lot has been changed within that last few hours.

Thanks, sorry for the re-do.

Comment 3

[Alex Buchanan [:abuchanan]]

Need this for 1.0 QA

Comment 4

[Dave Miller [:justdave]]

ok, made a fresh dump from the backup server, restored to opentochoice2 database on stage, and re-ran the two queries in comment 1, should be good to go.

Comment 5

[Alex Buchanan [:abuchanan]]

Reopening, because this has all the context.

Please import a production dump to opentochoice.stage.m.c

You'll need to run the SQL from comment 0

opentochoice2.stage.m.c exists, but is no longer needed.  This stage site can be deleted now.

Thanks.

Comment 6

[Dave Miller [:justdave]]

ok, done.

mysql> Update wp_options set option_value = 'http://opentochoice.stage.mozilla.com'
    -> where option_name = 'siteurl';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> Update wp_options set option_value = 'http://opentochoice.stage.mozilla.com'
    -> where option_name = 'home';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0