Changes between Version 20 and Version 21 of UserGuidelines/Admin/DataMigration/Haiti

Timestamp:

01/20/10 22:12:55 (15 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/Admin/DataMigration/Haiti

@@ -181 +181 @@
  * {{{SyntaxError: invalid table name: rms_sms_request}}}
 
-To resolve this
+To resolve this:
+ * Take site down (I did this the ugly way!)
+{{{
+vim /etc/crontab
+/etc/init.d/apache2 stop
+}}}
+ * Backup all Data
+{{{
+cd /home/haiti/prod
+mkdir databases2
+cp -ar databases/* databases2
+rm -rf databases
+}}}
+ * Copy data down locally to be able to analyse easily, export as CSV
+{{{
+tar cvf prod_db.tar databases2
+gzip -9 prod_db.tar
+sz prod_db.tar.gz
+}}}
+ * Allow model to recreate databases (owned as www-data)
+  * http://haiti.sahanafoundation.org
+ * Restore Data
+  * Edit CSV file using a text editor (not MS Excel!)
+   * remove reference tables & intiial records which are created by {{{models/zzz_1st_run.py}}} (NB This didn't seem to work properly on this occasion!)
+  * Import CSV segments to see which parts work:
+{{{
+cd /home/haiti/web2py
+python web2py.py -S prod -M -N
+db.import_from_csv_file(open('prod_part1.csv','rb'))
+db.commit()
+Ctrl+D
+}}}
 === Web Services ===
 Better to avoid locks & do without SSH login