Restore MariaDB mysqldump to Postgres?

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

I have a MariaDB mysqldump from Nextcloud v.20.2.2 with directories (was in an iocage) and am searching for a way to restore to the latest version of Nextcloud. The kicker is that the next install is Postgres. I have a few 100GB of data and a handful of users. What are my best options to get on latest version (truenas/kubernetes)?

2

Hey, have you found a solution to this? I am planning to migrate from Truenas to a VM and basically in the same situation. Can you please hint what steps did you take?
I am not sure what is the best way:

  1. Install Postgres in iocage then convert and then migrate to a new instance.
  2. Install Nextcloud VM and convert database from iocage to remote Postgtes then move folders.
  3. Install Nexcloud VM with MariaDB and Postgres, move everything from iocage and then convert to Postgres.