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


Ignore:
Timestamp:
01/27/10 01:10:07 (15 years ago)
Author:
Fran Boon
Comment:

--

Legend:

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

    v30 v31  
    44We want to be able to migrate data from Prod to Dev so that Testers / Documenters have real data to play with.
    55
    6 Easy as a 1-off:
     6For sqlite, this is easy:
    77{{{
    88/etc/init.d/apache2 stop
     
    1414Maintaining this should be possible via [wiki: DataMigration#WebServices Web Services]
    1515
    16 Also want to be able to migrate from the current sqlite backend to [wiki:InstallationGuidelinesMySQL MySQL]
    17 
    18 We often need to use this same tricks to deal with database consistency issues.[[BR]]
     16We often need to use this same trick to deal with database consistency issues.[[BR]]
    1917
    2018=== Note ===
     
    34434216) Replace all MyISAM lines in the sql with INNODB[[BR]]
    345343
    346 17) Drop the datbase using phpmyadmin and import the previously created sql[[BR]]
     34417) Drop the database using phpmyadmin and import the previously created sql[[BR]]
    347345
    34834618) Test everything once.[[BR]]