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

Hello,

restoring my full ncp-backup from NextcloudPi 1.55.3 on arm32 bulleseye on NextcloudPi v1.55.3 -
v24.11.1 for Raspberry Pi 4 running Armbian Linux 6.6.63-current-bcm2711 stopped.

My files had been restored. The backup was broken while restoring db-dump with "... invalid command at line 1".

If found Compatibility Change the current Armbian with Bookworm is running mariadb 10.11.6-0+deb12u1, as wirtten in the link, the client does not know the 1st line "/999999.*sandbox", my old arm32 version had this security feature implemented, the version 10.11.6 is missing it.

My workaround was patching /usr/local/bin/ncp-restore with as suggested in the link comments.

sed -i '1{/999999.sandbox/d}' "$TEMPDIR"/nextcloud-sqlbkp_.bak

sed -i '1{/999999.*sandbox/d}' "$TEMPDIR"/nextcloud-sqlbkp_*.bak
mysql -u root nextcloud <  "$TEMPDIR"/nextcloud-sqlbkp_*.bak || { echo "Error restoring nextcloud database"; exit 1; }

## RESTORE DATADIR 

I'll leave this information here, if some one has the same problem. For me we can close this issue ;-)

I'm not sure (it's a rare case) if it's worth to be fixed.

Inspect /usr/local/bin/ncp-restore, focusing on the MariaDB dump restore command and the temporary backup file it imports. Review the linked MariaDB compatibility change and test the restore path with the affected dump format and client versions. Done means the database restore succeeds without the reported invalid-command error.