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

Refers to:

  • Plesk 12.0 for Linux

Created:

2016-11-16 12:56:02 UTC

Modified:

2016-12-21 19:34:13 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

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 http://kb.plesk.com/Attachments/kcs-44168/MysqlShellBackend.pm
    # cp MysqlShellBackend.pm /usr/local/psa/PMM/agents/shared/Db/
Have more questions? Submit a request
Please sign in to leave a comment.