Migrating Mattermost with permission scheme

[tomw]

I have Mattermost running in a docker container that I would like to migrate to Cloudron.

I've seen the instructions in the Cloudron docs to use the Mattermost data export and then import this into Cloudron using the web terminal.

However, I read in the Mattermost docs that permissions schemes are not included in the data export. I have some custom permissions on the Mattermost instance (set during a free trial of the Mattermost Enterprise edition, and remain in place after downgrading back to "team mode") which I would like to retain.

The Mattermost docs suggest migrating by backing up the SQL database and restoring it on the new server (as well as the config.json and local storage directory).

Is there a reasonably straightforward way that I could restore an SQL dump into the database in my Mattermost instance on Cloudron?

[subven]

Did you saw https://docs.cloudron.io/guides/import-mysql and/or https://docs.cloudron.io/guides/import-postgresql/ ?

~~As for the config.json please take a look at https://docs.cloudron.io/apps/mattermost/#config~~ Edit: Migration guide covers this part very well

[tomw]

@subven Thank you! I had not seen those docs

It turned out that the Docker image of Mattermost used PostgreSQL, whereas on Cloudron if I'm not mistaken MySQL is used.

I tried converting migrating the PostgreSQL database to MySQL but it was a bit of a headache, so I have gone down the conventional route of using Mattermost's bulk export/import.