...
Expand | ||
---|---|---|
| ||
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.
".read" returns "memory", which is good.
|
SSH into your r6 box, wipeout the database, and load the sqlite dump into your dbconsole.
Code Block |
---|
# 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 mysql> sqlite>source .read /tmp/avalon.r5.dump |
".read" returns "memory", which is good.
Add yourself back in as administrator in the rails console
...