Migrate from RPi 4 to LXD?

[burger]

The Basics

• (Formatted as RPi – LXD)

• Try 1 - out of the box LXD

• Nextcloud Server version (e.g., 29.x.x):

  • 31.0.5.1 -- 30.0.1.2

• Operating system and version (e.g., Ubuntu 24.04):

  • Armbian-unofficial 24.8.1 Bookworm \l . 6.6.44-current-bcm2711 (aarch64) -- Debian GNU/Linux 12. 6.11.0-25-generic (x86_64)

• Web server and version (e.g, Apache 2.4.25):

  • Apache/2.4.62 (Debian) -- Apache/2.4.62 (Debian)

• PHP version (e.g, 8.3):

  • 8.3.21 -- 8.3.13

• mysql

  • 10.11.11-MariaDB -- 10.11.6-MariaDB

• Try 2 - apt update and apt upgrade in LXD container, listing only what changed

• PHP version (e.g, 8.3):

  • 8.3.21 -- 8.3.21

• mysql

  • 10.11.11-MariaDB -- 10.11.11-MariaDB

• Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)

  • NCP on RPi 4 -- NCP on LXD

• NextcloudPi version

  • v1.55.4 -- v1.55.3

• LXD NextcloudPi image

  • NextcloudPi_LXD_11-08-24.img

Summary of the issue you are facing:

I have a working NCP on an SD card running on a Raspberry Pi 4. I would like to migrate this to LXD. So I made a nc-backup. I am able to restore from this backup on the RPi4. To migrate to LXD, I then attempted to follow more-or-less the steps outlined here:

Guide to migrate your NCP instance from Docker to LXD

How to migrate your NCP docker container to LXD Disclaimer: This guide assumes, that you are using NCP >= 1.51.2. If you are on an earlier version, please upgrade first. 1. Setup LXD Upstream Guide: Linux Containers - LXD - Getting started Install snap. The following commands work on Debian based systems, for other linux distributions refer to the LXD documentationsudo apt install snapd sudo snap install core sudo snap install lxd If you require docker on your server and experience connec…

Unfortunately, the restore fails. Here is the output in the panel for Try 1:

restore files…
Restoring old ‘/var/www/nextcloud/data’ to ‘/var/www/nextcloud/data’…
restore database…
ERROR at line 1: Unknown command ‘-’.
Error restoring nextcloud database
Cleanup…

Seeing that the version of MariaDB on LXD was 10.11.6, maybe it is related to this issue:

NCP from RPi 4 to RPi 5 - problem with backup / restore

I got my new RPi 5 recently and just wanted to upgrade from my existing and functioning RPi 4 (NC Version 28). Here’s what I did so far: started fresh NCP on the RPi 5 (NC 30) made a backup from NCP (RPi 4) without data Restored RPi 4-Config into RPi 5 Tried to import NCP Backup Got this failure: extracting backup file /media/nextcloud-bkp_20250302_1740938529.tar.gz... restore files... Restoring old '/var/www/nextcloud/data' to '/var/www/nextcloud/data'... restore database... ERROR at line 1…

and

Restore broken ncp-restore MariaDB Dump 999999 sandbox invalid command / at line 1

and

MariaDB Dump File Compatibility Change - MariaDB.org

The first line is indeed:

/*M!999999- enable the sandbox mode */

But my attempts at a workaround by modifying the first line of the database with the sed command, re-tarring it, getting the permissions correct and attempting a restore failed.

Try 2 not only failed, it also froze the panel window in the browser.

Any help would be greatly appreciated.