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.
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…
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.