Migrate Database

Dump r5 database (mysql on pawpaw)

mysqldump -u avalonweb -p avalonweb --tables role_maps --skip-create-options > /tmp/avalon.r5.dump.sql

There are some mysql specific statements in the dump file that need to be removed to load it into sqlite.


Load to r6 database (sqlite locally)

bundle exec rails dbconsole 
sqlite> DELETE FROM role_maps;
sqlite> .read /tmp/avalon.r5.dump.sql


Migrate Config files

???