Changes between Version 31 and Version 32 of UserGuidelines/Admin/DataMigration/Haiti


Ignore:
Timestamp:
02/01/10 00:39:52 (12 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/Admin/DataMigration/Haiti

    v31 v32  
    220220Ctrl+D
    221221}}}
     222==== Migration Error recovery ====
     223 * Error: "Unknown column \'gis_location.lon_min\' in \'field list\'"
     224 * Cause: MySQL didn't have the field, model did & the migration log in databases\ said that the migration had happened.
     225To recover:
     226{{{
     227vim /etc/crontab
     228#0-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
     229
     230ln -sf /etc/apache2/sites-available/test-maintain /etc/apache2/sites-enabled/test
     231/etc/init.d/apache2 force-reload
     232
     233http://haiti-test.sahanafoundation.org/phpmyadmin/index.php?db=haititest&table=gis_location
     234Export as SQL
     235
     236rm -f /home/haiti/test/databases/a54f35709b0d09d927454f2b745571db_gis_location.table
     237
     238mysql
     239\r haititest
     240drop TABLE gis_location;
     241\q
     242
     243vim /home/haiti/test/models/00_db.py
     244migrate=True
     245ln -sf /etc/apache2/sites-available/uat /etc/apache2/sites-enabled/test
     246/etc/init.d/apache2 force-reload
     247
     248http://haiti-test.sahanafoundation.org/test/
     249
     250http://haiti-test.sahanafoundation.org/phpmyadmin/index.php?db=haititest&table=gis_location
     251Import SQL
     252
     253vim /etc/crontab
     2540-59/1 * * * * www-data cd /home/haiti/web2py/ && python web2py.py -C -D 1 >> /tmp/cron.output 2>&1
     255
     256vim /home/haiti/test/models/00_db.py
     257migrate=False
     258}}}
     259
    222260=== Web Services ===
    223261Better to avoid locks & do without SSH login