Changes between Version 30 and Version 31 of UserGuidelines/Admin/DataMigration/Haiti
- Timestamp:
- 01/27/10 01:10:07 (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UserGuidelines/Admin/DataMigration/Haiti
v30 v31 4 4 We want to be able to migrate data from Prod to Dev so that Testers / Documenters have real data to play with. 5 5 6 Easy as a 1-off:6 For sqlite, this is easy: 7 7 {{{ 8 8 /etc/init.d/apache2 stop … … 14 14 Maintaining this should be possible via [wiki: DataMigration#WebServices Web Services] 15 15 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]] 16 We often need to use this same trick to deal with database consistency issues.[[BR]] 19 17 20 18 === Note === … … 344 342 16) Replace all MyISAM lines in the sql with INNODB[[BR]] 345 343 346 17) Drop the dat base using phpmyadmin and import the previously created sql[[BR]]344 17) Drop the database using phpmyadmin and import the previously created sql[[BR]] 347 345 348 346 18) Test everything once.[[BR]]