MariaDB 导入数据时 ERROR 1118 (42000) at line 1278: Row size too large (＞ 8126)报错

导入zabbix用户的数据到MariaDB 中   

[root@myserver zabbix]#  zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz|mysql -uzabbix -p123456 zabbix

ERROR 1118 (42000) at line 1278: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.

In current row format, BLOB prefix of 0 bytes is stored inline.

在创建库加上set innodb_strict_mode=0即可 如下:

MariaDB [(none)]> create database zabbix character set utf8 collate utf8_bin;

Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> grant all on zabbix.* to zabbix@localhost identified by '123456';

Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> set innodb_strict_mode=0;

Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> exit

Bye

[root@myserver my.cnf.d]# systemctl restart mariadb.service

[root@myserver my.cnf.d]# zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz|mysql -uzabbix -p123456 zabbix

[root@myserver my.cnf.d]#