Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

This documentation is a work in progress.

Migrate Config Files

config/authentication.yml has a new structure with a different section for each rails environment. Edit your authentication particulars to incorporate this new structure.  An example is found in config/authentication.yml.example. 

???


Migrate Database

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)

Sqllite3 doesn't like mysql dump files so a transformation script needs to be run on it. Download https://raw.githubusercontent.com/dumblob/mysql2sqlite/master/mysql2sqlite, make it executable, and run it on the dump file.

SSH into your r6 box, wipeout the database, and load the sqlite dump into your dbconsole.

#convert mysql dump to mysqlite if you need to import into mysqlite (dev testing)
chmod +x mysql2sqlite
./mysql2sqlite avalon.r5.dump.sql > avalon.r5.dump.sqlite
 
# 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.sqlite

".read" returns "memory", which is good.

Add yourself back in as administrator. --might not need this anymore

g = Admin::Group.find('administrator')
g.users += ["archivist1@example.com"]
g.save!

 

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 user@fedora3.host
# Setup config/fedora3.yml in your Avalon 6 app (url will be http://localhost:9999/fedora)
bundle exec rake avalon:migrate:repo
#Review output and fix/rerun it


Migrate Database Tables

# Run script to map fedora 3 pids in database to newly minted fedora 4 noids
bundle exec rake avalon:migrate:db

 

 

 

 


  • No labels