Symptoms

Backup creation via Backup Manager fails:

Error:  mysql "db_example"
Failed to execute backup database

Warning:        mysql "db_example"
Failed to pack files Test_collation_jdoe_10_1510110129 in /var/lib/psa/dumps/clients/jdoe/domains/domain.tld/databases/db_example [ 13416833024 bytes free of 21069725696 bytes total on mount point 0]

    Warning:        mysql "db_example"
    mysqldump: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/

Cause

Backup creation fails in case of MySQL db character set set is not supported by PA Management node. The behavior was considered as internal software issue with id PPA-2824 and will be fixed in future PA updates.

Resolution

As a workaround you can add additional character set in /usr/share/mysql/charsets/Index.xml on Plesk Automation Management node. You can do it using following steps:

  1. Login to PA Management node and open /usr/share/mysql/charsets/Index.xml in text editor.

  2. Add new character set within <charsets> </charsets> section. For example:

    <?xml version='1.0' encoding="utf-8"?>
<charsets max-id="99">
...
<charset name="utf8mb4">
  <family>Unicode</family>
  <description>UTF-8 Unicode</description>
  <collation name="utf8_bin"            id="83">
    <flag>primary</flag>
    <flag>binary</flag>
    <flag>compiled</flag>
  </collation>
</charset>
...
</charsets>

Internal content