当前位置：网站首页>错误代码： 1118 - Row size too large (＞ 8126). Changing some columns to TEXT or BLOB may help. In current

错误代码： 1118 - Row size too large (＞ 8126). Changing some columns to TEXT or BLOB may help. In current

2022-08-11 09:34:00 【qykhhr】

修改 my.ini 文件为文后内容

根据自己 MySQL 安装目录来设置
basedir=“D:/mysql-5.7.38-winx64/”
datadir=“D:/mysql-5.7.38-winx64/data/”

关闭严格模式

innodb_strict_mode=0

日期相关的配置

sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO

导入完成后再给这两个配置注释掉

[mysqld]
innodb_strict_mode=0
sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
basedir="D:/mysql-5.7.38-winx64/"
datadir="D:/mysql-5.7.38-winx64/data/"
port=3306

max_allowed_packet = 5000M
key_buffer_size= 3840M

sort_buffer_size = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
thread_cache_size = 32
query_cache_size = 256M
interactive_timeout=1814400
wait_timeout=1814400

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

原网站

版权声明
本文为[qykhhr]所创，转载请带上原文链接，感谢
https://blog.csdn.net/qq_46070108/article/details/126221119