609350 - Import SQL script with wiki data to master.support

Status: RESOLVED FIXED

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

Description

[Paul Craciunoiu [:paulc]]

New SQL data ready to import on stage master!

It's in my khan home folder: /home/pcraciunoiu/wiki_media_11_01.sql

I didn't include the media gallery data but it shouldn't be necessary.

Just do exactly what you did for bug 604705 please.

Thanks!

Comment 1

[Paul Craciunoiu [:paulc]]

Can we resync with a db from prod before importing that?

Comment 2

[Paul Craciunoiu [:paulc]]

Jeremy ran this today around 4pm.

Comment 3

[James Socol [:jsocol, :james]]

Looks like this was done without dropping/creating the database first. Our migrations create a number of tables that won't be in a production database, so that's an important step.

To unhork everything, we basically need to do:

* Drop the current database and recreate it.
* Import a dump from production.
* Run `schematic migrations/`
* Import Paul's SQL dump (khan:/home/pcraciunoiu/wiki_media_11_01.sql)

Comment 4

[James Socol [:jsocol, :james]]

This is preventing QA & Co from testing. Sorry the original instructions weren't clear. Hopefully comment 3 is better.

Comment 5

[Jeremy Orem [:oremj]]

Yesterday I:
* Dropped the DB
* Created the DB
* Imported dump from prod
* ran Paul's SQL

Is there anyway to fix this without going through the entire process again?

Comment 6

[James Socol [:jsocol, :james]]

If you didn't run schematic migrations between the import and Paul's SQL, then the only other option is to manually try to get all the migrations to apply.

Comment 7

[Jeremy Orem [:oremj]]

Done.