Force Install YNH on debian 11 because backup

What type of hardware are you using: VPS bought online
What YunoHost version are you running: YNH
How are you able to access your server: SSH
Are you in a special context or did you perform specific tweaking on your YunoHost instance ?: Probleme with debian 12

Describe your issue

Hi

Can we force a reinstall on debian 11 to complete a restoration based on debian 11 and then migrate ?
I am not able to restore my backup after installing debian 12. I have mistakes on restoring apps Wordpress / Nextcloud.

Thank’s

Share relevant logs or error messages

Cannot install YNH with debian 11 anymore

If you have “mistakes” then what are they …

If you “cannot” then explain why … we do not read crystal balls

Hello,

If I try to install yunohost on debian 11
[FAIL] YunoHost is only available for the version 12 (Bookworm) of Debian, you are using '11.11'.

On debian 12 / YNH 12.0.6, when I want to restore apps I’ve got the same error
WARNING - ERROR at line 1: Unknown command '\-'.

wordpress backup restoration
https://paste.yunohost.org/raw/xizasokepu

nextcloud backup restoration
https://paste.yunohost.org/raw/worabuwuyo

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/nextcloud-tar/

then extract the tar file

cd nextcloud-tar
tar -xvf  nextcloud-pre-upgrade1.tar  

edit the file and remove the first line ( should be something like /*!999999\- enable the sandbox mode */ )

nano nextcloud-tar/apps/nextcloud/backup/db.sql

delete the file nextcloud-pre-upgrade1.tar from the directory nextcloud-tar

rm nextcloud-tar/nextcloud-pre-upgrade1.tar

recreate the tar file

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

Then rename the original one it to keep it in secure place…

mv /home/yunohost.backup/archives/nextcloud-pre-upgrade1.tar /home/yunohost.backup/archives/nextcloud-pre-upgrade1.tar-ORI

and replace the new one edited on the folder archives

mv /root/nextcloud-pre-upgrade1.tar /home/yunohost.backup/archives/

And try restore the backup… I am not sure, but you can try it

Hi,
I made a backup 24h ago, all updates done, before migration.

Where I can find the dump file ? I can’t find in the .tar file

Ok, sorry, so if you have do all the updates before, I may be wrong !!

The backups are in /home/yunohost.backup/archives

You have also the command

yunohost backup list
yunohost backup --help

Did you have do all the migrations after the update ??

Ok so it work, I mixed some of your answers :wink:

before migration, I made an backup on my computer.
after migration, I didn’t make qu backup, and I fucked up the network config.
si I did reinstall from scratch my VPS on Debian 12 but I couldn’t retore the backup because of the ERRORS shown in previous message.

I’ve found, the db.sql files in the archive .tar (apps/nextcloud/backup/db.sql) and manually deleted the first line /*M!999999\- enable the sandbox mode */

then upload my archive again on my VPS and succeed to restore the apps.

Thank’s a lot @rodinux !

Yep ! happy for you !

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.