615364 - Practice migration import on support-stage.mozilla.com

Status: RESOLVED FIXED

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

Description

[Paul Craciunoiu [:paulc]]

Our migration is ready to go to support-stage.m.c. Steps:

1. Import a fresh copy of the production database to support-stage

2. Run |schematic migrations|

3. Import SQL script from khan @
/home/pcraciunoiu/migration.sql

4. Extract the following zip file (also on khan) and place its contents in media/uploads/ under kitsune
/home/pcraciunoiu/gallery.zip

After extraction, the structure should be something like:
media/uploads/gallery/videos/thumbnails
media/uploads/gallery/images/thumbnails
As per our discussions and current configuration, please make sure the videos folder is also accessible from the CDN.

5. Yay, done! Thanks!


Hope I didn't miss anything.

Comment 1

[Paul Craciunoiu [:paulc]]

(In reply to comment #0)
> 
> 4. Extract the following zip file (also on khan) and place its contents in
> media/uploads/ under kitsune
> /home/pcraciunoiu/gallery.zip
Ah, as James points out, before doing this, it's better to erase the gallery directory (media/uploads/gallery), to avoid collisions. Then continue with the extraction and video CDN set-up.

Comment 2

[Paul Craciunoiu [:paulc]]

Forgot one step here:
0. Drop the staging database. We're already past that now though :)

Comment 3

[Shyam Mani [:fox2mike]]

All done!