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>
    

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079 5b048d9bddf8048a00aba7e0bdadef37 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF