Page tree

Versions Compared


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



Sqllite3 doesn't like mysql dump files so a transformation script needs to be run on it. Download, 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 += [""]!


Migrate Fedora Objects


SSH tunnel or open up your fedora3 server to your new Avalon app: 
ssh -L 9999:localhost:8983
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