As I'm working on a re-write of the PTO in Django, I need to write a script to migrate the existing database into the new app. For this I need a dump of the old one. Also, with a bug dump I'll be able to test that the new export works under "load". At some point we'll need to shut down the old one and migrate to my new app but that's something for later.
mpressman, I asked Peter to file this bug, since I think some aspects might need to be sanitized, although, not in a way that would break Peter's import script. I'm not really sure what the policy is for that stuff.
btw. I think this lives on the tm-b02 database cluster.
:jabba can you help me get this going?
Peter, the intranet_pto database on the tm-b02 cluster only contains one table called pto. Does that sound correct? If so, where would you like for me to put the dump?
Assignee: server-ops-database → mpressman
(In reply to comment #4) > Peter, the intranet_pto database on the tm-b02 cluster only contains one > table called pto. Does that sound correct? If so, where would you like for > me to put the dump? That is correct. Only one table. Well, I have my key on the elmo server which is bm-l10n-dashboard01 Any other ideas for where to put it?
I've scrubbed the person field which contains the email addresses, but there is a field for detail which explains the reason for pto, should this be hashed out as well? In the meantime, I'll find a way to get access to bm-l10n-dashboard01
(In reply to comment #6) > I've scrubbed the person field which contains the email addresses, but there > is a field for detail which explains the reason for pto, should this be > hashed out as well? In the meantime, I'll find a way to get access to > bm-l10n-dashboard01 When you scrub out the email address, can you at least hash it so that I can distinguish between users. I'm aware of the security precaution but eventually we need to run this migration properly when moving from the old app to the new app. Shall I share my public key so that I can scp it from some other VM?
I was unable to gain access, so I have emailed you the dump as it is pretty small. The hash of the users will be the same for each unique user
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Created attachment 550407 [details] It worked! Screenshot of a very unfinished List widget. Shows that all entries successfully imported into the new structure.
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.