kay0u
commented
7 hours ago It seems to be a regression on the mariadb side: https://talk.plesk.com/threads/mariadb-failed-imports-error-at-line-1-unknown-command.374423/
Someone gave a workaround here.
You can:
- Do a backup of your backup
- Open the file db.sql in your backup
- Remove the first line which should be something like
/*!999999\- enable the sandbox mode */ - Try to restore again
Describe the bug
In October, I started having some hardware issues, so I backed up several of my yunohost apps. These backups were created when Yunohost was still running on Debian 11. I had a few Wordpress sites that I had backed up using the webadmin. Since then, I have different hardware and installed Yunohost with Debian 12. Several of my other yunohost apps have restored with no issue, but none of my Wordpress sites will restore. I am using the webadmin to restore these backups.
Context
Steps to reproduce
I moved the back up file containing muliple Wordpress sites to the yunohost.backup folder and is viewable from the webadmin backups. I try to restore the back up as usual, but get errors. ERROR at line 1: Unknown command '-'.
Restore fails. I am unable to restore any of the Wordpress sites from this backup or any of my other older Wordpress backups.
https://paste.yunohost.org/raw/qiceboremu
Expected behavior
I expect to be able to move the backup file to the yunohost.backup folder. Go to webadmin backups and restore from the webadmin. I expect the Wordpress sites to restore at their current version, and would likely need to perform an update on the app later.
Logs
https://paste.yunohost.org/raw/qiceboremu