Restore Nexcloud from YNH11 to YNH 12: error

[yunorasp]

What type of hardware are you using: Other(?)
What YunoHost version are you running: 12.0.9.2
What app is this about: nextcloud

Describe your issue

Hello, and thank you for all the work you do on Yunohost !

I’m testing a “migration” from a raspberry Pi 4 (ARM) on Yunohost 11.3.0.2 to a Zimablade (X86) on a fresh Yunohost 12.0.9.2 install.
I’m just trying to restore backup of different apps.
My main test is to restore a backup of Nextcloud 29.0.5 from Raspberry YNH 11 to Zimablade YNH 12

I’ve read this topic

Force Install YNH on debian 11 because backup

Is your backups recents ? Or olds ones ? it seems an error with mariadb versions. Between mariadb 10.4 and mariadb 10.5 this error happens… see here more explanation about this: I think the solution is to remove first the line of the dump file on a text editor… Perhaps you can first copy the backup file nextcloud-pre-upgrade1.tar or nextcloud-pre-upgrade2.tar in a folder nextcloud-tar, mkdir /root/nextcloud-tar cp -a /home/yunohost/backup/archives/nextcloud-pre-upgrade1.tar /root/nextclou…

I deleted the first line of the .sql backup (with Vim not Nano can it be the problem ?) but still got this error message

2025-01-08 16:23:28,963: DEBUG - + mysql --user=nextcloud__2 --password=********** --default-character-set=utf8mb4 --batch nextcloud__2
2025-01-08 16:23:28,980: WARNING - ERROR at line 1: Unknown command ‘-’.
2025-01-08 16:23:28,981: DEBUG - + ynh_exit_properly
2025-01-08 16:23:28,982: DEBUG - + [[ restore =~ ^install$|^upgrade$|^restore$ ]]
2025-01-08 16:23:29,594: ERROR - Impossible de restaurer nextcloud__2 : Une erreur s’est produite dans le script de restauration de l’application

Anyone got an idea to help me ?

Thanks

Share relevant logs or error messages

https://paste.yunohost.org/raw/asetufutuh

[rodinux]

@yunorasp

WARNING - ERROR at line 1: Unknown command ‘-’.

It seems similar with an issue we found with the script upgrade

Fix upgrade exploding when $app is nextcloud__2, __3 etc because the virtual apt/dpkg package is named with - and not _

But here you are on a script restore…
Why your backup is not at the last nextcloud upgrade 29.0.10 ??

I am not sure…

How is the first line of your file db.sql ? Is it something like this ?

-- MariaDB dump xx.xx  Distrib xx.xx.XX-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: nextcloud__2
-- ------------------------------------------------------

[yunorasp]

Hi,
Thank you for your help !
After some tries and errors with a lot of data so a lot of time spent, it worked !

I don’t know what went wrong the first times with
nano nextcloud-tar/apps/nextcloud/backup/db.sql
and
delete the file nextcloud-pre-upgrade1.tar from the directory nextcloud-tar

because it enventually worked !

but i had to change this lines because the .tar wasn’t recognized by YNH:

cd …
$ tar -cf nextcloud-pre-upgrade1.tar nextcloud-tar

with no “cd…”
and

$ tar -cf nextcloud-pre-upgrade1.tar *

So now all my apps are up and running on YNH 12, thank you all the team for all your good work