Article ID: 127134, created on Oct 12, 2015, last review on Oct 12, 2015

  • Applies to:
  • Plesk Automation 11.5

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>
          <alias>utf-8</alias>
          <collation name="utf8_general_ci"     id="33">
           <flag>primary</flag>
           <flag>compiled</flag>
          </collation>
          <collation name="utf8_bin"            id="83">
            <flag>binary</flag>
            <flag>compiled</flag>
          </collation>
        </charset>
    ...
    </charsets>
    

Search Words

mysqldump: Character set 'utf8mb4' is not a compiled character set and is not specified in the

mysql database character set

utf8mb4

database collation

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF