mysqldump needs extra setting to support newer nextcloud versions

[BoxedBrain]

Problem:
As the newer versions of nextcloud need utf8mb4 support, the mysqldump should be run with --default-character-set=utf8mb4 to not break files/comments with emoji in it.
See also: https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html

Also make sure your backup strategy still work. If you use mysqldump make sure to add the --default-character-set=utf8mb4 option. Otherwise your backups are broken and restoring them will result in ? instead of the emojis, making files inaccessible.

Suggestion:
Maybe add to the sql.details file another row we could set needed parameters our self?

[asifbacchus]

I don't really use NextCloud much anymore so I appreciate you pointing stuff like this out! What would you prefer, a manual 'options' line in sql.details or should I just update the cmd in the script?

[BoxedBrain]

Adding another line to the conf. file the user could add any mysqldump parameter would be more flexible I think.