Restore hosted discourse on local self-hosted

AI-generated summary

phallguy is attempting to restore a backup from their Discourse-hosted Business plan instance onto a local self-hosted setup for development purposes, but encounters a schema version mismatch error: You're trying to restore a more recent version of the schema. You should migrate first! Despite confirming the local instance is up-to-date via /admin/upgrade, the issue persists. Falco asks if the local instance is tracking the tests-passed branch and whether plugins are installed. phallguy confirms using the official install guide on VirtualBox Ubuntu but hasn’t configured plugins locally. Falco identifies the issue likely stems from missing migrations from the discourse-user-notes plugin, which is included in the Business plan. To achieve a full 1-to-1 restore, Falco advises installing all plugins listed for Business plans at https://www.discourse.org/plugins#business. phallguy acknowledges and plans to implement this solution, noting this experiment aims to validate future in-house migration readiness.

I’m hacking on some custom themes and sso and want to work locally instead of against our discourse-hosted instance. I’ve taken a backup of the hosted instance and uploaded to my local self-hosted instance.

When I try to restore I get an error about versions

[2019-07-25 21:16:55]   Current version: 20190717133743
[2019-07-25 21:16:55]   Restored version: 20190725020422
[2019-07-25 21:16:55] EXCEPTION: You're trying to restore a more recent version of the schema. You should migrate first!
[2019-07-25 21:16:55] /var/www/discourse/lib/backup_restore/restorer.rb:250:in `validate_metadata'

I’ve already visited /admin/upgrade on the local instance and it tells me everything is already up-to-date.

How can I get this backup installed locally?

As a side note, this turned into an experiment about what would happen if we ever needed to bring it in-house and I’d like to be more confident that we can do that in the future.

Thanks all!

Is your self-hosted instance installed using our official guide and tracking the tests-passed branch?

I installed following the guide here but setup a local Ubuntu in VirtualBox instead of using DigitalOcean. I’m not sure specifically about what branch I’m tracking. Dashboard version shows this:

And upgrade page:

Are you hosted in which plan?

You may be missing a migration that comes from a plugin.

Yes the site I took the backup from is hosted with y’all. We’re on the “Business” plan. I haven’t made any attempt to get plugins working locally yet.

Oh I see, per this error message:

Is is missing a migration from GitHub - discourse/discourse-user-notes: Plugin for Staff users to create notes on users · GitHub.

To get a full 1-to-1 copy, you will want to install the plugins listed here for standard AND business: Plugin directory | Discourse - Civilized Discussion

Awesome I’ll take a crack at that. Thanks!