Page tree

Versions Compared

Key

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

This documentation is a work in progress.

Migrate

...

  • 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. 
  • config/controlled_vocabulary.yml  – should be copied from R5 to R6 to support data migrations

Migrate Database

Dump r5 database (mysql on pawpaw)

...


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.

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
 
# 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.

...