This documentation is a work in progress.
Dump r5 database (mysql on pawpaw)
Load to r6 database
If you are a developer wanting to test your migration on sqlite locally, follow these 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.
SSH into your r6 box, wipeout the database, and load the sqlite dump into your dbconsole.
".read" returns "memory", which is good.
Add yourself back in as administrator in the rails console
Migrate Fedora Objects
SSH tunnel or open up your fedora3 server to your new Avalon app:
keep the ssh mirror running in another tab as you do the next steps.
Setup config/fedora3.yml in your Avalon 6 app
The fedora3.yml should work without change, but if you do have trouble, here's an example fedora3.yml for the avalon demo server.
Run the migration! You can watch it run on your target avalon by going to <you avalon url>/admin/migration_report
After this command is finished, look through the report and see which items have failed and troubleshoot using the errors listed.
Migrate Database Tables
Delete Failed Bookmarks