Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

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.

Code Block
#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
bundle exec rake avalon:wipeout   
# 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

This ".read" returns "memory", which is good.In rails

console, you might need to remove the cached role maps.Add yourself back in as administrator. --might not need this anymore

Code Block
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: 
ssh -L 9999:localhost:8983 user@fedora3.host
Code Block
# 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

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

...