What type of hardware are you using: Virtual machine What YunoHost version are you running: 12.1.37 How are you able to access your server: SSH
Direct access via physical keyboard/screen Are you in a special context or did you perform specific tweaking on your YunoHost instance ?: Moved : yunohost.app, yunohost.multimedia
Describe your issue
I was not able to restore a nextcloud backup. From what I understand related to character encoding, probably utf8 vs utf8_mb4. I manually extracted the backup and removed the SQL lines (500000+…) related to Memories app that was causing issue. I’ll reinstall memories.
I don’t know if its NC.memories related or general.
Should I report a bug in GitHub ?
Share relevant logs or error messages
Info : [#####++…] > Restoring the MySQL database… Exception in thread Thread-8: Traceback (most recent call last): File “/usr/lib/python3.11/threading.py”, line 1038, in _bootstrap_inner Attention : -------------- Attention : INSERT INTO memories_planet_geometry VALUES self.run() File “/usr/lib/python3/dist-packages/yunohost/utils/process.py”, line 157, in run self.queue.put((self.log_callback, line.decode(“utf-8”).strip(“\n”))) ^^^^^^^^^^^^^^^^^^^^ UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xe6 in position 36: invalid continuation byte ^C
If removing manually memories tables fails, I would try removing them within mariadb (via CLI or phpmyadmin).
mysql -u root
# MariaDB shell
CREATE DATABASE remove_memories;
EXIT;
# bash shell
mysql -u root remove_memories < apps/nextcloud/backup/db.sql # import in new created remove_memories db
mysql -u root
# mariaDB shell
USE remove_memories;
SHOW TABLES;
DROP TABLE IF EXISTS oc_memories... # all the memories tables...?
EXIT;
# bash shell
mysqldump -u root remove_memories > /home/yunohost.backup/archives/apps/nextcloud/backup/db.sql # if db.sql was extracted inj this folder
Then update the archive and restore it.
Finally remove remove_memories db.
# badsh shell
mysql -u root
# bash mariaDB
SHOW DATABASES;
DROP DATABASE remove_memories; # be careful...
EXIT;
