Changes between Version 16 and Version 17 of UserGuidelines/Admin/DataMigration/Haiti

Timestamp:

01/20/10 19:54:42 (13 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -1 +1 @@
 [wiki:Haiti]
 ----
-== Data Migration ==
+== Data Migration & Consistency ==
 
 We want to be able to migrate data from Prod to Dev so that Testers / Documenters have real data to play with.
 
-Easy!:
+Easy as a 1-off:
 {{{
 /etc/init.d/apache2 stop
@@ -13 +13 @@
 }}}
 
+Maintaining this should be possible via [wiki: DataMigration#WebServices Web Services]
 
 Also want to be able to migrate from the current sqlite backend to [wiki:InstallationGuidelinesMySQL MySQL]
+
+We often need to use this same tricks to deal with database consistency issues.
 
 === CSV ===
 Beware DB locks!
  * Don't keep Web2Py shell open longer than necessary
+ * Consider goign into Maintenance Mode on the Webserver & disabling the Web2Py cron in {{{/etc/crontab}}}
 
 {{{
-python web2py.py -S prod -M
+python web2py.py -S prod -M -N
 db.export_to_csv_file(open('db.csv','wb'))
 Ctrl+D
@@ -30 +34 @@
 NB Do CSV file edits in a text editor, not MS Excel (MS Excel makes the dumps unusable!)
 
+NB Be careful of file permissions!
+ * All files in the databases folder should be {{{chown www-data:www-data}}}
+ * If the 1st run of the model happens in the Python shell, then they will be owned by root...
+
 {{{
-python web2py.py -S dev -M
+python web2py.py -S dev -M -N
 db.import_from_csv_file(open('db.csv','rb'))
 db.commit()
@@ -115 +123 @@
     *  http://localhost:8000/sahana/gis/location/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/gis/location.xml
     *  http://localhost:8000/sahana/pr/person/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/pr/person.xml
-    *  http://localhost:8000/sahana/or/organisation/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/or/organisation.xml?components=office
-    *  http://localhost:8000/sahana/or/office/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/or/office.xml
+    *  http://localhost:8000/sahana/or/organisation/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/or/organisation.xml
+     * This should pull in all components, so no need to do:
+     *  http://localhost:8000/sahana/or/office/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/or/office.xml
     *  http://localhost:8000/sahana/or/contact/create?format=xml&fetchurl=http://haiti.sahanafoundation.org/prod/or/contact.xml 
  * BluePrintSynchronisation