From Nextcloud AIO back to Nextcloud

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

I’m trying to convert my nextcloud aio instance back into a standard installation. In my experiment, standard means - based on Debian, Docker and Portainer.

This works so far except for importing the users. The cloud admin is imported, but all other users are not, for reasons I don’t understand.

What I did:

  • Stop all Containers of Nextcloud AIO
  • Copy database-dump.sql from /var/lib/docker/volumes/nextcloud_aio_database_dump/_data
  • Adjust user in database: sed -i ‘s/oc_nextcloud/oc_admin/g’ database-dump.sql
  • Copy database to running nextcloud portainer (new instance) - docker cp database-dump.sql :/database-dump.sql
  • Login in to Database Container - docker exec -it /bin/bash

Delete & recreate Database, import dump:
PGPASSWORD=“xxxxxxxxxxxxxxxxxxxxxxx” psql -h localhost -U oc_admin -c “DROP DATABASE “nextcloud_database”;” -d postgres

PGPASSWORD=“xxxxxxxxxxxxxxxxxxxxxxxx” psql -h localhost -U oc_admin -c “CREATE DATABASE “nextcloud_database”;” -d postgres
Import Dump

PGPASSWORD=“xxxxxxxxxxxxxxxxxxxxxxxxxxxx” psql -h localhost -U oc_admin -d nextcloud_database -f database-dump.sql

Restart Containers Nextcloud & Database

Login with admin on new nextcloud possible - but all users missing:
The number of existing users is displayed but the users themselves are missing

2

I can’t really help, but have you checked whether the other users are in the database dump?

If so, you could create a new user (with a new name) in the new Nextcloud. Then perhaps take a look at a new database dump and compare the new user’s entry with the old users. You might notice something.

3

I’m not sure it is wise to run dump replace operation on the DB export, please try adopting the DB and users from the export. maybe migration to AiO helps to perform the reverse task as well…

sounds strange as well - could it be some browser caching issue? did you try incognito mode?