675077 - [pamo] Get a new db/file dump from production

Status: RESOLVED FIXED

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

Description

[Jeff Balogh (:jbalogh)]

Can we start importing a new db dump from prod tonight?

Let's give it a new name so that we can switch pamo over to the new db without any downtime once the sync is done.

Comment 1

[Wil Clouser [:clouserw]]

Krupa has some SQL to run after this also

Comment 2

[krupa raj[:krupa]]

Attachment: preview accounts

Comment 3

[krupa raj[:krupa]]

(In reply to comment #1)
> Krupa has some SQL to run after this also

https://bugzilla.mozilla.org/show_bug.cgi?id=583862#c5

Comment 4

[krupa raj[:krupa]]

Comment on attachment 549840 [details]
preview accounts

UPDATE groups SET rules="*:*" where name="QA" limit 1;
UPDATE auth_user SET is_superuser=1 WHERE id IN (SELECT user_id FROM groups_users JOIN groups ON groups.id = groups_users.group_id WHERE groups.name="QA");

UPDATE `config` SET `value` = 'a:2:{s:3:"msg";s:254:"<strong>This is a PREVIEW server!</strong> Changes here are not saved and will be overwritten with data from production. If you''re localizing your strings and want them to stick around, do it on <a href="https://addons.mozilla.org/localizers/">AMO</a>";s:12:"msg_purified";s:334:"<strong>This is a PREVIEW server!</strong> Changes here are not saved and will be overwritten with data from production. If you''re localizing your strings and want them to stick around, do it on <a href="http://outgoing.stage.mozilla.com/v1/5ae7f4b833c4c84d754d4a365a6814f1bd019924/https%3A//addons.mozilla.org/localizers/">AMO</a>";}' WHERE `config`.`key` = 'l10n_motd' LIMIT 1 ;

Comment 5

[Wil Clouser [:clouserw]]

Attachment: SQL to run

There was some confusion over the SQL to run.  This is the correct SQL to run, please ignore anything above this comment.  Thanks.

Comment 6

[Wil Clouser [:clouserw]]

Heh, sorry Krupa!  Comment 4 didn't exist when I started mine.  IT: 4 and 5 are equivalent.

Comment 7

[Kumar McMillan [:kumar]]

FYI this is blocking bug 659794 since I want to test on preview before going live with such a high traffic URL.

Comment 8

[Wil Clouser [:clouserw]]

This bug is almost 2 weeks old now, what's going on with this import?

Comment 9

[Jeremy Orem [:oremj]]

I started the import earlier this morning.

Comment 10

[Wil Clouser [:clouserw]]

Thanks.  Please rsync the filesystems too.

Comment 11

[Jeremy Orem [:oremj]]

Yep, that has been running since the import started.

Comment 12

[Jeremy Orem [:oremj]]

Still running.