0

When run the following command:

zcat /usr/share/doc/zabbix-server-mysql-3.4.1/create.sql.gz | mysql -u root -p zabbix

it shows the following error:

ERROR 1366 (HY000) at line 3390: Incorrect string value: '\xD0\xA1' for column 'units' at row 1

Screenshot

How can this be resolved?

Zakir
  • 1
  • Which distribution, which package is that ? – Richlv Sep 15 '17 at 21:19
  • Sir it is-->repo-->rpm -ivh http://repo.zabbix.com/zabbix/3.4/rhel/7/x86_64/zabbix-release-3.4-1.el7.centos.noarch.rpm
    yum -y install zabbix-server-mysql zabbix-web-mysql     – Zakir Sep 16 '17 at 03:17
  • i had resolved this issue by changing my database setting UTF-8 https://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors?answertab=active#tab-top – Zakir Sep 16 '17 at 05:30
  • Possible duplicate of [How to fix "Incorrect string value" errors?](https://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors) – bummi Sep 16 '17 at 05:37

1 Answers1

0

I had resolved this issue by changing my database setting UTF-8.

Help Tag: How to fix "Incorrect string value" errors?

Zakir
  • 1