Restoring data from Nextcloud v25 to AIO v32

ℹ️ Support
1
Support intro

Sorry to hear you’re facing problems. :slightly_frowning_face:

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

The Basics

  • Nextcloud Server version (e.g., 29.x.x): AIO v32.0.4
  • Operating system and version (e.g., Ubuntu 24.04): Debian 13
  • Web server and version (e.g, Apache 2.4.25): embedded within AIO
  • Reverse proxy and version _(e.g. nginx 1.27.2): nginx v29.0.1
  • PHP version (e.g, 8.3): embedded within AIO
  • Is this the first time you’ve seen this error? (Yes / No): Yes
  • When did this problem seem to first start? Installation
  • Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.): AIO Docker
  • Are you using CloudfIare, mod_security, or similar? (Yes / No) No

Summary of the issue you are facing:

I had a previous Nextcloud v25 instance which had to be upgraded. I saved all data from the nextcloud container (simple copy from nextcloud:/var/www/html/data to the host). I have now installed a fresh AIO instance and want to restore all data (host → Nextcloud).

The question is: what’s the container/destination folder? Is it still nextcloud-aio-nextcloud:/var/www/html/data? I couldn’t find any clue in the documentation…

Thanks in advance for any help!

2

Hi, see all-in-one/migration.md at main · nextcloud/all-in-one · GitHub

3

Thanks for the link!

I’m actually wondering how to perform the step 3 “Recreate all users that were present on your former installation”: I saved the Nextcloud v25 database (.sql file), can I just import this file into the new AIO instance to recreate all accounts and their associated privileges? Won’t it fail due to database format evolution (tables, formats, etc.)?

I also can’t go through step 4 yet, as the destination folder for the backup is located on an external NAS and its owner still has to configure the NAS. Does it mean I need to stop all containers manually? I.e. using Portainer to stop them?

Thanks for guidance, I’m pretty afraid of breaking the whole stack. :grimacing:

4

In that case, see https://github.com/nextcloud/all-in-one/blob/main/migration.md#migrate-the-files-and-the-database

5

Thanks, but I already read this guide and it’s not applicable:

  • The source Nextcloud version is v25, while the destination AIO version is v32. I then can’t use the user_migration app either…
  • Installed applications in the new instance will be slightly different from the old one.
  • I can’t upgrade the previous instance up to v32, as the stack broke at the very first step (v25 → v26) and is not accessible anymore (containers are still running but accessing the web interface returns error messages regarding the broken database).
  • Moreover, the old instance uses MySQL and not Postgresql: changing database engine would definitely crash the whole thing.

I may however try to install a postgreSQL engine on another machine and try to convert the current MySQL file to postgre. Do you think it’s worth trying to go through step 3 with a v25 backup?

Thanks again for your help!

6

Sounds like a good plan! I would highly recommend to additionally upgrade on that machine to the latest v32. Afterwards migrating to AIO should be straight forward :slight_smile:

7

Unfortunately, this is impossible: the previous instance is broken! :man_shrugging:

8

Hi all,

I’m trying to apply the migration procedure described in all-in-one/migration.md at main · nextcloud/all-in-one · GitHub, but stumble on many issues:

  • I started the previous container (Nextcloud v25) and managed to install postgresql.
  • The server is supposed to listen localhost:5432. Ping is OK, but `hostname -I` returns 172.19.0.4 and 172.20.0.3. Are these the adresses Postgre is listening to?
  • I created the new database, receiving no error.
  • I then tried to run the convert command occ db:convert-type --all-apps --password “$PG_PASSWORD” pgsql “$PG_USER” 127.0.0.1 “$PG_DATABASE”: returns that php is required.
  • Tried php occ db:convert-type --all-apps --password “$PG_PASSWORD” pgsql “$PG_USER” 127.0.0.1 “$PG_DATABASE”: returns that sudo is required.
  • Tried sudo -u www-data php occ db:convert-type --all-apps --password “$PG_PASSWORD” pgsql “$PG_USER” 127.0.0.1 “$PG_DATABASE”: returns that “password authentication failed for user “www-data””
  • Fails obviously with sudo -u postgres…

I then don’t know how to get further. I still have my .sql file at hand: is there any tool that could read the mySQL file and convert it to a PostgreSQL file, so I could import the converted file into Nextcloud AIO? I can’t see any other solution as the official migration procedure doesn’t work (for me)…

Thanks in advance for any help!