Invalid mysql database collation, expected utf8

[sergio-bershadsky]

Seems to be the aim is utf8 database, but some reason it is latin instead.

[berngp]

@nikitinsm just pushed a branch which forces the MySQL DB to UTF8. Need to test things out but feel free to give it a try.

[sergio-bershadsky]

It still latin1 fields caused of the mysql dump I think not my.ini config

for t in $(mysql --user=zabbix --password=zabbix  --database=zabbix -e "show tables";);do echo "Altering" $t;mysql --user=zabbix --password=zabbix --database=zabbix -e "ALTER TABLE $t CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;";done

This solves problem you can add it after db dump is fully loaded

[berngp]

Thanks Sergey,
I'll follow you advice.
Cheers

On Sat, Mar 14, 2015 at 11:44 PM, Sergey Nikitin notifications@github.com
wrote:

It still latin1 fields caused of the mysql dump I think not my.ini config

for t in $(mysql --user=zabbix --password=zabbix --database=zabbix -e "show tables";);do echo "Altering" $t;mysql --user=zabbix --password=zabbix --database=zabbix -e "ALTER TABLE $t CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;";done

This solves problem you can add it after db dump is fully loaded

—
Reply to this email directly or view it on GitHub
#14 (comment).

[sergio-bershadsky]

BTW I have installed zabbix directly (without docker) from deb and DB is utf-8