Versions Compared

Old Version 35

changes.mady.by.user Brian Keese

Saved on

compared with

New Version 36

changes.mady.by.user Brian Keese

Saved on

Key

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

...

Expand
title...Follow these sqlite instructions

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.

Code Block
chmod +x mysql2sqlite
./mysql2sqlite avalon.r5.dump.sql > avalon.r5.dump.sqlite
 
#then on r6
bundle exec rails dbconsole
sqlite> .read /tmp/avalon.r5.dump.sqlite

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

Clear role_map cache

Code Block
languagebash
bundle exec rails c
> Rails.cache.delete("RoleMapHash")

 

 


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

...

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

Clear role_map cache (TODO: fix me)

Rails won't use your newly imported role_map data unless you clear it from cache.

Code Block
languagebash
Rails.cache.delete("RoleMapHash")

 

Migrate Fedora Objects

SSH tunnel or open up your fedora3 server to your new Avalon app:

...