Importing a data snapshot: Difference between revisions
Content added Content deleted
imported>Paulproteus No edit summary |
imported>Paulproteus No edit summary |
||
Line 14: | Line 14: | ||
* http://openhatch.org/people/ |
* http://openhatch.org/people/ |
||
* http://127.0.0.1:8000/people/ |
* http://127.0.0.1:8000/people/ |
||
== More about this == |
|||
* We go through some effort to remove private information before we publish user data in these snapshots. The code for that is in [http://gitorious.org/openhatch/oh-mainline/blobs/master/mysite/customs/management/commands/snapshot_public_data.py snapshot_public_data.py]. |
|||
* We want to be saving these snapshots periodically, hopefully once a day. We don't do that yet. |
|||
* We don't snapshot every single table. If you find there's something that we don't publish that we should, do [http://openhatch.org/bugs/ file a bug]! |
|||
* '''Known issue''': On trying to perform the import, I get this MySQL warning: "Incorrect string value: '\xC8\x9B' for column 'first_name' at row 1". That's bad news, and I'm fixing it. |
|||
Revision as of 23:20, 31 October 2010
When you get your own instance of the OpenHatch code running, you'll discover you're missing the data that are on the main OpenHatch site. So we take periodic snapshots of the data on the main openhatch.org site.
Where you can find the snapshots
- FIXME
How to use a snapshot
To load a snapshot into your database, you can run this command from your local install:
./bin/mysite loaddata snapshot.json
You can test that it worked by loading up your local people page and the live one. Do you have the about the same number of people? Click on these things:
More about this
- We go through some effort to remove private information before we publish user data in these snapshots. The code for that is in snapshot_public_data.py.
- We want to be saving these snapshots periodically, hopefully once a day. We don't do that yet.
- We don't snapshot every single table. If you find there's something that we don't publish that we should, do file a bug!
- Known issue: On trying to perform the import, I get this MySQL warning: "Incorrect string value: '\xC8\x9B' for column 'first_name' at row 1". That's bad news, and I'm fixing it.