Closed Bug 675077 Opened 10 years ago Closed 10 years ago

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

Categories

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

All
Other
task
Not set
critical

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: jbalogh, Assigned: oremj)

References

Details

Attachments

(1 file, 1 obsolete file)

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.
Krupa has some SQL to run after this also
Assignee: server-ops → mpressman
Component: Server Operations → Server Operations: Database
Blocks: 659794
Attached file preview accounts (obsolete) —
(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 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 ;
Attached file 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.
Attachment #549840 - Attachment is obsolete: true
Heh, sorry Krupa!  Comment 4 didn't exist when I started mine.  IT: 4 and 5 are equivalent.
FYI this is blocking bug 659794 since I want to test on preview before going live with such a high traffic URL.
Severity: minor → major
This bug is almost 2 weeks old now, what's going on with this import?
Severity: major → critical
Assignee: mpressman → jeremy.orem+bugs
I started the import earlier this morning.
Thanks.  Please rsync the filesystems too.
Yep, that has been running since the import started.
Still running.
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.