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