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

  • Applies to:
  • Operations Automation 5.5
  • 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>
      <collation name="utf8_bin"            id="83">
        <flag>primary</flag>
        <flag>binary</flag>
        <flag>compiled</flag>
      </collation>
    </charset>
    ...
    </charsets>
    

Search Words

In current version of mysql dumper the backup manager has an issue with charset utf8mb4: mysqldump: Character set \'utf8mb4\' is not a compiled character set and is not specified in the \'/usr/share/mysql/charsets/Index.xml\' file\" Current Version is Ver 10.13 Distrib 5.1.73. Is it possible to provide an upgrade to version

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

mysql database character set

utf8mb4

mysql dumper

database collation

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079 5b048d9bddf8048a00aba7e0bdadef37 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF