Database migration

[Wattana Pattanagul]

Hi,

I have canvas LMS running self-hosted since 2022. Until last night, the system got corrupted. I managed to install the system to a new host, with a newer canvas version due to OS and dependencies. I try to import the old database to the new system, but some pages like Assignment, Settings, etc showed "Page Error". Is there anyway I can migrate the old database to the new system without having to go to incremental upgrade the system. Please help since a lot of faculties and students are depending on it.

Thanks,

Wattana

[Cody Cutrer]

No. You need to install and run migrations from quarterly historical releases of Canvas.

Cody Cutrer

Software Engineer

Instructure

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/canvas-lms-users/2b175128-300a-4568-94aa-50a9c4ef30d6n%40googlegroups.com.

[Wattana Pattanagul]

Thank Cody. Do I need to set up canvas lms to a fully-function system before running db:migrate or can I clone the source code and run db:migrate from command line?

[Cody Cutrer]

You’ll need to have `bundle install` and enough configuration set up for connecting to the database and probably security.yml. But no need to compile assets for the front end.

Cody Cutrer

Software Engineer

Instructure

To view this discussion visit https://groups.google.com/d/msgid/canvas-lms-users/ad43d4d6-3213-4f14-a0b1-0f91e0689c60n%40googlegroups.com.

[Wattana Pattanagul]

Thanks Cody. It works! I managed to incrementally update the database as you suggest and plug it into the new system. Also I moved /tmp/files from the old system to the new system. Now everything seems to work perfectly, except when I tried to use speedgrader, it won't show up and displayed a running circle asking me to wait indefinitely. Do you have any idea what I did wrong?

Wattana