Confirmed users, Bureaucrats and Sysops emeriti
1,737
edits
Update:Remora Database Migration: Difference between revisions
→Updates, 2007-02-07
| Line 615: | Line 615: | ||
In the case above, when using the migrated data set, the -mz file is returned because it is selected at random. The file should actually be the -fx file. | In the case above, when using the migrated data set, the -mz file is returned because it is selected at random. The file should actually be the -fx file. | ||
* Verify main.description is getting trimmed at max 250 chars. when migrating to summary | * Verify main.description is getting trimmed at max 250 chars. when migrating to summary | ||
== Final Migration == | |||
[[User:clouserw|Clouserw]] performed the final migration on 2007-03-05: | |||
I expect this script will be retired at this point, but just to be complete, this is what happened with the final run: | |||
* Initial AMOv2 database was loaded with a db dump from v2 from 2007-03-05 08:10am | |||
*Initial AMOv3 database was loaded with [http://viewvc.svn.mozilla.org/vc/addons/trunk/site/app/config/sql/remora.sql?revision=2206&view=markup remora.sql from r2206] | |||
*migration.conf was setup, etc. Final command run was ''./migration.py -MAv --recalculateHash > migration.out 2>&1''. We had to run the --recalculateHash flag so the script would download new addons (if it finds a hash in the db, it doesn't download the addon) | |||
*The following previews failed to migrate (but there are blank entries for them in the db): | |||
https://addons.mozilla.org/images/previews/acid_burn-1.jpg for addon_id 453 | |||
https://addons.mozilla.org/images/previews/acid_burn-2.jpg for addon_id 453 | |||
https://addons.mozilla.org/images/previews/futurama-4.jpg for addon_id 1240 | |||
https://addons.mozilla.org/images/previews/kiminbu?-1.jpg for addon_id 2904 | |||
https://addons.mozilla.org/images/previews/ook?_video_ook!-4.jpg for addon_id 2584 | |||
https://addons.mozilla.org/images/previews/webos_xul#_extension-1.jpg for addon_id 2945 | |||
https://addons.mozilla.org/images/previews/ook?_video_ook!-5.jpg for addon_id 2584 | |||
https://addons.mozilla.org/images/previews/print/print_preview-2.jpg for addon_id 1778 | |||
*Ran the [http://people.mozilla.org/~clouserw/public/remora/remora_supplement.final.sql supplemental SQL] | |||
*''./migration.py --clearAddons -a `cat amov2_addons_marked_for_deletion`'' to remove the old disabled addons. Just some housekeeping. | |||