ERROR 1071 (42000) at line 142: Specifiedkey was too long; max key length is 767 bytes

[root@zzz-server-mysql-3.0.1]# cd /usr/share/doc/zabbix-server-mysql-3.0.1

[root@zzz-server-mysql-3.0.1]# zcat create.sql.gz | mysql -uroot zabbix -p

Warning: Using a password on the commandline interface can be insecure.

Enter password:

ERROR 1071 (42000) at line 142: Specifiedkey was too long; max key length is 767 bytes

[root@zzz-server-mysql-3.0.1]#

解决办法：

zabbix库字符集设置成latin1，搞定咯。