mysqldump: Got error: 1231: Variable 'character_set_client' can't be set to the value of 'ucs2' when trying to connect

Created:

2016-11-16 12:56:02 UTC

Modified:

2017-08-16 17:36:40 UTC

0

Was this article helpful?


Have more questions?

Submit a request

mysqldump: Got error: 1231: Variable 'character_set_client' can't be set to the value of 'ucs2' when trying to connect

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

  • Getting the following error while taking backup of a database using 'Backup Manager'

    mysqldump: Got error: 1231: Variable 'character_set_client' can't be set to the value of 'ucs2' when trying to connect
  • Failed database have tables with UCS2 character set only.

Cause

Database is having tables only with 'ucs2' character set. Not a single 'utf8' collation defined while creating the tables.This issue is confirmed as a software issue #PPPM-2380

Resolution

  1. Replace /usr/local/psa/PMM/agents/shared/Db/MysqlDbiBackend.pm with attached file
    # cp /usr/local/psa/PMM/agents/shared/Db/MysqlDbiBackend.pm{,.backup}
    # cd /root
    # wget https://support.plesk.com/hc/article_attachments/115004386829/MysqlShellBackend.pm
    # cp MysqlShellBackend.pm /usr/local/psa/PMM/agents/shared/Db/

Attachments:

Have more questions? Submit a request
Please sign in to leave a comment.