This documentation is a work in progress.
Dump r5 database (mysql on pawpaw)
mysqldump -u avalonweb -p avalonweb -no-create-info --complete-insert --tables annotations api_tokens bookmarks courses identities ingest_batches playlist_items playlists role_maps users > /tmp/avalon.r5.dump.sql
Load to r6 database (sqlite locally)
SSH into your r6 box, wipeout the database, and load the sqlite dump into your dbconsole.
# ensure that Fedora, Solr, and the DB are clean
# it will ask you to verify the targets are correct
bundle exec rake avalon:wipeout
#go into the database console and import sqlite data
bundle exec rails dbconsole
sqlite> .read /tmp/avalon.r5.dump
".read" returns "memory", which is good.
Add yourself back in as administrator in the rails console
g = Admin::Group.find('administrator')
g.users += ["firstname.lastname@example.org"]
Migrate Fedora Objects
SSH tunnel or open up your fedora3 server to your new Avalon app:
#port 9999 stands for your local mirror of your fedora3.host:8983 import source
#if 9999 doesn't work, try another port nearby
ssh -L 9999:localhost:8983 email@example.com
keep the ssh mirror running in another tab as you do the next steps.
Setup config/fedora3.yml in your Avalon 6 app
The fedora3.yml should work without change, but if you do have trouble, here's an example fedora3.yml for the avalon demo server.
Run the migration! You can watch it run on your target avalon by going to <you avalon url>/admin/migration_report
bundle exec rake avalon:migrate:repo
After this command is finished, look through the report and see which items have failed and troubleshoot using the errors listed.
Migrate Database Tables
# Run script to map fedora 3 pids in database to newly minted fedora 4 noids
bundle exec rake avalon:migrate:db
Delete Failed Bookmarks
#This will delete any bookmarks that point to failed items
bundle exec rake avalon:migrate:bookmark_cleanup