Make utf8mb4 default when backing up mysql databases
When i backup database with Plesk (either with Export/Import feature or with Backup Manager), it loses all characters outside Unicode BMP (all characters > 0xFFFF).
It's because mysqldump default charset is utf8, not utf8mb4.
This should be changed, for example, if database contains at least one field with utf8mb4 charset - mysqldump should be run with --default-character-set=utf8mb4 option.
Settings in /etc/mysql/conf.d/mysqldump.cnf are not respected too, it works when i use mysqldump from command-line, but doesn't work when i export or backup db with plesk.
MySQL dump 10.13 Distrib 5.7.25, for Linux (x86_64)
MySQL Server version 5.7.25-0ubuntu0.16.04.2
Plesk version: Plesk Onyx 17.8.11
Thank you for your input! We will consider this functionality in upcoming releases if it will be popular.
Everyone, please continue voting for this feature if you consider it important.
AmaZili Communication commented
Backup should be able to store and retrieve database whatever the charset and encoding !