nextcloud_on_docker icon indicating copy to clipboard operation
nextcloud_on_docker copied to clipboard

Backup - Nextcloud - Enabling MySQL 4-byte support -> adjust mysqldump flags

Open james-cook opened this issue 5 years ago • 0 comments

Check: https://docs.nextcloud.com/server/16/admin_manual/configuration_database/mysql_4byte_support.html

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

So, if the generated nextcloud config.php file contains: 'mysql.utf8mb4' => true,

then the mysqldump command should contain the additional flag: --default-character-set=utf8mb4

See: \roles\prep_backup\templates\backup_nextcloud.sh.j2

james-cook avatar Jan 13 '20 15:01 james-cook