1118 - Row size too large (＞ 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMI
ERROR 1118 (42000) at line 5: 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.
解决方案：
关闭InnoDB严格模式
set global innodb_strict_mode = 0;
再次导入即可。
对于 Mac OS X El Capitan 上的 MySQL 5.7：
OS X 在 /usr/local/mysql/support-files/my-default.cnf 提供示例配置文件
要添加变量，首先停止服务器并将上面的文件复制到，/usr/local/mysql/etc/my.cnf
cmd : sudo cp /usr/local/mysql/support-files/my-default.cnf /usr/local/mysql/etc/my.cnf
注意：如果它不存在，请在“mysql”下创建“etc”文件夹。
cmd : sudo mkdir /usr/local/mysql/etc
一旦 my.cnf 在 etc. 下创建，就该在其中设置变量了。
cmd: sudo nano my.cnf
在 [mysqld] 下面设置变量
[mysqld]
innodb_log_file_size = 512M
innodb_strict_mode = 0
现在启动一个服务器！
对于 MySQL 8：
innodb_log_file_size = 512Minnodb_strict_mode = 0表结构schema如下，可重现。
CREATE TABLE test1 (
NodeID int(11) NOT NULL DEFAULT ‘0’ ,
Step int(11) DEFAULT ‘0’ ,
FK_Flow varchar(150) DEFAULT NULL,
Name varchar(200) DEFAULT NULL,
Tip varchar(100) DEFAULT NULL ,
WhoExeIt int(11) DEFAULT ‘0’ ,
ReadReceipts int(11) DEFAULT ‘0’ ,
CondModel int(11) DEFAULT ‘0’ ,
CancelRole int(11) DEFAULT ‘0’ ,
CancelDisWhenRead int(11) DEFAULT ‘0’ ,
IsTask int(11) DEFAULT ‘1’ ,
IsRM int(11) DEFAULT ‘1’ ,
DTFrom varchar(50) DEFAULT NULL ,
DTTo varchar(50) DEFAULT NULL ,
IsBUnit int(11) DEFAULT ‘0’ ,
FocusField varchar(50) DEFAULT NULL ,
SaveModel int(11) DEFAULT ‘0’ ,
IsGuestNode int(11) DEFAULT ‘0’ ,
NodeAppType int(11) DEFAULT ‘0’ ,
FWCSta int(11) DEFAULT ‘0’ ,
SelfParas varchar(500) DEFAULT NULL ,
RunModel int(11) DEFAULT ‘0’ ,
SubThreadType int(11) DEFAULT ‘0’ ,
PassRate float DEFAULT NULL ,
SubFlowStartWay int(11) DEFAULT ‘0’ ,
SubFlowStartParas varchar(100) DEFAULT NULL ,
ThreadIsCanDel int(11) DEFAULT ‘0’ ,
ThreadIsCanShift int(11) DEFAULT ‘0’ ,
IsAllowRepeatEmps int(11) DEFAULT ‘0’ ,
AutoRunEnable int(11) DEFAULT ‘0’ ,
AutoRunParas varchar(100) DEFAULT NULL ,
AutoJumpRole0 int(11) DEFAULT ‘0’ ,
AutoJumpRole1 int(11) DEFAULT ‘0’ ,
AutoJumpRole2 int(11) DEFAULT ‘0’ ,
WhenNoWorker int(11) DEFAULT ‘0’ ,
SendLab varchar(50) DEFAULT NULL ,
SendJS varchar(999) DEFAULT NULL ,
SaveLab varchar(50) DEFAULT NULL ,
SaveEnable int(11) DEFAULT ‘1’ ,
ThreadLab varchar(50) DEFAULT NULL ,
ThreadEnable int(11) DEFAULT ‘0’ ,
ThreadKillRole int(11) DEFAULT ‘0’ ,
JumpWayLab varchar(50) DEFAULT NULL ,
JumpWay int(11) DEFAULT ‘0’ ,
JumpToNodes varchar(200) DEFAULT NULL ,
ReturnLab varchar(50) DEFAULT NULL ,
ReturnRole int(11) DEFAULT ‘0’ ,
ReturnAlert varchar(999) DEFAULT NULL ,
IsBackTracking int(11) DEFAULT ‘1’ ,
ReturnField varchar(50) DEFAULT NULL ,
ReturnReasonsItems varchar(999) DEFAULT NULL ,
CCLab varchar(50) DEFAULT NULL ,
CCRole int(11) DEFAULT ‘0’ ,
CCWriteTo int(11) DEFAULT ‘0’ ,
ShiftLab varchar(50) DEFAULT NULL ,
ShiftEnable int(11) DEFAULT ‘0’ ,
DelLab varchar(50) DEFAULT NULL ,
DelEnable int(11) DEFAULT ‘0’ ,
EndFlowLab varchar(50) DEFAULT NULL ,
EndFlowEnable int(11) DEFAULT ‘0’ ,
PrintHtmlLab varchar(50) DEFAULT NULL ,
PrintHtmlEnable int(11) DEFAULT ‘0’ ,
PrintPDFLab varchar(50) DEFAULT NULL ,
PrintPDFEnable int(11) DEFAULT ‘0’ ,
PrintZipLab varchar(50) DEFAULT NULL ,
PrintZipEnable int(11) DEFAULT ‘0’ ,
PrintDocLab varchar(50) DEFAULT NULL ,
PrintDocEnable int(11) DEFAULT ‘0’ ,
TrackLab varchar(50) DEFAULT NULL ,
TrackEnable int(11) DEFAULT ‘1’ ,
HungLab varchar(50) DEFAULT NULL ,
HungEnable int(11) DEFAULT ‘0’ ,
SearchLab varchar(50) DEFAULT NULL ,
SearchEnable int(11) DEFAULT ‘0’ ,
WorkCheckLab varchar(50) DEFAULT NULL ,
WorkCheckEnable int(11) DEFAULT ‘0’ ,
AskforLab varchar(50) DEFAULT NULL ,
AskforEnable int(11) DEFAULT ‘0’ ,
HuiQianLab varchar(50) DEFAULT NULL ,
HuiQianRole int(11) DEFAULT ‘0’ ,
TCLab varchar(50) DEFAULT NULL ,
TCEnable int(11) DEFAULT ‘0’ ,
WebOffice varchar(50) DEFAULT NULL ,
WebOfficeEnable int(11) DEFAULT ‘0’ ,
PRILab varchar(50) DEFAULT NULL ,
PRIEnable int(11) DEFAULT ‘0’ ,
CHLab varchar(50) DEFAULT NULL ,
CHEnable int(11) DEFAULT ‘0’ ,
AllotLab varchar(50) DEFAULT NULL ,
AllotEnable int(11) DEFAULT ‘0’ ,
FocusLab varchar(50) DEFAULT NULL ,
FocusEnable int(11) DEFAULT ‘0’ ,
ConfirmLab varchar(50) DEFAULT NULL ,
ConfirmEnable int(11) DEFAULT ‘0’ ,
CCIsAttr int(11) DEFAULT ‘0’ ,
CCFormAttr varchar(100) DEFAULT ‘’ ,
CCIsStations int(11) DEFAULT ‘0’ ,
CCStaWay int(11) DEFAULT ‘0’ ,
CCIsDepts int(11) DEFAULT ‘0’ ,
CCIsEmps int(11) DEFAULT ‘0’ ,
CCIsSQLs int(11) DEFAULT ‘0’ ,
CCSQL varchar(200) DEFAULT ‘’ ,
CCTitle varchar(100) DEFAULT ‘’ ,
CCDoc text ,
FWCLab varchar(100) DEFAULT ‘’ ,
FWCShowModel int(11) DEFAULT ‘1’ ,
FWCType int(11) DEFAULT ‘0’ ,
FWCNodeName varchar(100) DEFAULT ‘’ ,
FWCAth int(11) DEFAULT ‘0’ ,
FWCTrackEnable int(11) DEFAULT ‘1’ ,
FWCListEnable int(11) DEFAULT ‘1’ ,
FWCIsShowAllStep int(11) DEFAULT ‘0’ ,
FWCOpLabel varchar(50) DEFAULT ‘’ ,
FWCDefInfo varchar(50) DEFAULT ‘’ ,
SigantureEnabel int(11) DEFAULT ‘0’ ,
FWCIsFullInfo int(11) DEFAULT ‘1’ ,
FWC_X float(11,2) DEFAULT ‘300.00’ ,
FWC_Y float(11,2) DEFAULT ‘500.00’ ,
FWC_H float(11,2) DEFAULT ‘300.00’ ,
FWC_W float(11,2) DEFAULT ‘400.00’ ,
FWCFields varchar(50) DEFAULT ‘’ ,
FWCIsShowTruck int(11) DEFAULT ‘0’ ,
FWCIsShowReturnMsg int(11) DEFAULT ‘0’ ,
FWCOrderModel int(11) DEFAULT ‘0’ ,
FWCMsgShow int(11) DEFAULT ‘0’ ,
SFLab varchar(200) DEFAULT ‘’ ,
SFSta int(11) DEFAULT ‘0’ ,
SFShowModel int(11) DEFAULT ‘1’ ,
SFCaption varchar(100) DEFAULT ‘’ ,
SFDefInfo varchar(50) DEFAULT ‘’ ,
SFActiveFlows varchar(100) DEFAULT NULL,
SF_X float(11,2) DEFAULT ‘5.00’ ,
SF_Y float(11,2) DEFAULT ‘5.00’ ,
SF_H float(11,2) DEFAULT ‘300.00’ ,
SF_W float(11,2) DEFAULT ‘400.00’ ,
SFFields varchar(50) DEFAULT ‘’ ,
SFShowCtrl int(11) DEFAULT ‘0’ ,
SFOpenType int(11) DEFAULT ‘0’ ,
FrmThreadLab varchar(200) DEFAULT ‘’ ,
FrmThreadSta int(11) DEFAULT ‘0’ ,
FrmThread_X float(11,2) DEFAULT ‘5.00’ ,
FrmThread_Y float(11,2) DEFAULT ‘5.00’ ,
FrmThread_H float(11,2) DEFAULT ‘300.00’ ,
FrmThread_W float(11,2) DEFAULT ‘400.00’ ,
FrmTrackLab varchar(200) DEFAULT ‘’ ,
FrmTrackSta int(11) DEFAULT ‘0’ ,
FrmTrack_X float(11,2) DEFAULT ‘5.00’ ,
FrmTrack_Y float(11,2) DEFAULT ‘5.00’ ,
FrmTrack_H float(11,2) DEFAULT ‘300.00’ ,
FrmTrack_W float(11,2) DEFAULT ‘400.00’ ,
CheckNodes varchar(50) DEFAULT ‘’ ,
DeliveryWay int(11) DEFAULT ‘0’ ,
FTCLab varchar(50) DEFAULT ‘’ ,
FTCSta int(11) DEFAULT ‘0’ ,
FTCWorkModel int(11) DEFAULT ‘0’ ,
FTC_X float(11,2) DEFAULT ‘5.00’ ,
FTC_Y float(11,2) DEFAULT ‘5.00’ ,
FTC_H float(11,2) DEFAULT ‘300.00’ ,
FTC_W float(11,2) DEFAULT ‘400.00’ ,
SelectAccepterLab varchar(50) DEFAULT ‘’ ,
SelectAccepterEnable int(11) DEFAULT ‘0’ ,
BatchLab varchar(50) DEFAULT ‘’ ,
BatchEnable int(11) DEFAULT ‘0’ ,
OfficeOpenLab varchar(50) DEFAULT ‘’ ,
OfficeOpenEnable int(11) DEFAULT ‘0’ ,
OfficeOpenTemplateLab varchar(50) DEFAULT ‘’ ,
OfficeOpenTemplateEnable int(11) DEFAULT ‘0’ ,
OfficeSaveLab varchar(50) DEFAULT ‘’ ,
OfficeSaveEnable int(11) DEFAULT ‘1’ ,
OfficeAcceptLab varchar(50) DEFAULT ‘’ ,
OfficeAcceptEnable int(11) DEFAULT ‘0’ ,
OfficeRefuseLab varchar(50) DEFAULT ‘’ ,
OfficeRefuseEnable int(11) DEFAULT ‘0’ ,
OfficeOverLab varchar(50) DEFAULT ‘’ ,
OfficeOverEnable int(11) DEFAULT ‘0’ ,
OfficeMarksEnable int(11) DEFAULT ‘1’ ,
OfficePrintLab varchar(50) DEFAULT ‘’ ,
OfficePrintEnable int(11) DEFAULT ‘0’ ,
OfficeSealLab varchar(50) DEFAULT ‘’ ,
OfficeSealEnable int(11) DEFAULT ‘0’ ,
OfficeInsertFlowLab varchar(50) DEFAULT ‘’ ,
OfficeInsertFlowEnable int(11) DEFAULT ‘0’ ,
OfficeNodeInfo int(11) DEFAULT ‘0’ ,
OfficeReSavePDF int(11) DEFAULT ‘0’ ,
OfficeDownLab varchar(50) DEFAULT ‘’ ,
OfficeDownEnable int(11) DEFAULT ‘0’ ,
OfficeIsMarks int(11) DEFAULT ‘1’ ,
OfficeTemplate varchar(100) DEFAULT ‘’ ,
OfficeIsParent int(11) DEFAULT ‘1’ ,
OfficeTHEnable int(11) DEFAULT ‘0’ ,
OfficeTHTemplate varchar(200) DEFAULT ‘’ ,
SelectorModel int(11) DEFAULT ‘5’ ,
FK_SQLTemplate varchar(50) DEFAULT ‘’ ,
FK_SQLTemplateText varchar(50) DEFAULT ‘’ ,
IsAutoLoadEmps int(11) DEFAULT ‘1’ ,
IsSimpleSelector int(11) DEFAULT ‘0’ ,
IsEnableDeptRange int(11) DEFAULT ‘0’ ,
IsEnableStaRange int(11) DEFAULT ‘0’ ,
SelectorP1 text ,
SelectorP2 text ,
SelectorP3 text ,
SelectorP4 text ,
X int(11) DEFAULT ‘0’ ,
Y int(11) DEFAULT ‘0’ ,
OfficeOpen varchar(50) DEFAULT ‘’ ,
OfficeOpenTemplate varchar(50) DEFAULT ‘’ ,
OfficeSave varchar(50) DEFAULT ‘’ ,
OfficeAccept varchar(50) DEFAULT ‘’ ,
OfficeRefuse varchar(50) DEFAULT ‘’ ,
OfficeOver varchar(50) DEFAULT ‘’ ,
OfficeMarks int(11) DEFAULT ‘1’ ,
OfficeReadOnly int(11) DEFAULT ‘0’ ,
OfficePrint varchar(50) DEFAULT ‘’ ,
OfficeSeal varchar(50) DEFAULT ‘’ ,
OfficeInsertFlow varchar(50) DEFAULT ‘’ ,
OfficeIsTrueTH int(11) DEFAULT ‘0’ ,
WebOfficeFrmModel int(11) DEFAULT ‘0’ ,
ICON varchar(70) DEFAULT ‘’ ,
NodeWorkType int(11) DEFAULT ‘0’ ,
FlowName varchar(200) DEFAULT ‘’ ,
FrmAttr varchar(300) DEFAULT ‘’ ,
TimeLimit float(11,2) DEFAULT ‘2.00’ ,
TWay int(11) DEFAULT ‘0’ ,
TAlertRole int(11) DEFAULT ‘0’ ,
TAlertWay int(11) DEFAULT ‘0’ ,
WarningDay float(11,2) DEFAULT ‘1.00’ ,
WAlertRole int(11) DEFAULT ‘0’ ,
WAlertWay int(11) DEFAULT ‘0’ ,
TCent float(11,2) DEFAULT ‘2.00’ ,
CHWay int(11) DEFAULT ‘0’ ,
IsEval int(11) DEFAULT ‘0’ ,
OutTimeDeal int(11) DEFAULT ‘0’ ,
DoOutTime varchar(300) DEFAULT ‘’ ,
Doc varchar(100) DEFAULT ‘’ ,
IsExpSender int(11) DEFAULT ‘1’ ,
DeliveryParas varchar(600) DEFAULT NULL,
NodeFrmID varchar(50) DEFAULT ‘’ ,
IsCanDelFlow int(11) DEFAULT ‘0’ ,
TodolistModel int(11) DEFAULT ‘0’ ,
TeamLeaderConfirmRole int(11) DEFAULT ‘0’ ,
TeamLeaderConfirmDoc varchar(100) DEFAULT ‘’ ,
IsHandOver int(11) DEFAULT ‘0’ ,
BlockModel int(11) DEFAULT ‘0’ ,
BlockExp varchar(200) DEFAULT ‘’ ,
BlockAlert varchar(100) DEFAULT ‘’ ,
BatchRole int(11) DEFAULT ‘0’ ,
BatchListCount int(11) DEFAULT ‘12’ ,
BatchParas varchar(500) DEFAULT ‘’ ,
FormType int(11) DEFAULT ‘1’ ,
FormUrl varchar(300) DEFAULT ‘http://’ ,
TurnToDeal int(11) DEFAULT ‘0’ ,
TurnToDealDoc varchar(200) DEFAULT ‘’ ,
NodePosType int(11) DEFAULT ‘0’ ,
IsCCFlow int(11) DEFAULT ‘0’ ,
HisStas varchar(3000) DEFAULT ‘’ ,
HisDeptStrs varchar(3000) DEFAULT ‘’ ,
HisToNDs varchar(50) DEFAULT ‘’ ,
HisBillIDs varchar(50) DEFAULT ‘’ ,
HisSubFlows varchar(30) DEFAULT ‘’ ,
PTable varchar(100) DEFAULT ‘’ ,
ShowSheets varchar(100) DEFAULT ‘’ ,
GroupStaNDs varchar(500) DEFAULT NULL,
RefOneFrmTreeType varchar(100) DEFAULT ‘’ ,
AtPara varchar(500) DEFAULT ‘’ ,
TSpanHour float(50,2) DEFAULT ‘0.00’,
SubFlowLab varchar(50) DEFAULT ‘’,
SubFlowEnable int(11) DEFAULT ‘0’,
PRIMARY KEY (NodeID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
来源地址：https://blog.csdn.net/qq_44866828/article/details/125260574
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
![[mysql]mysql8修改root密码](https://static.528045.com/imgs/22.jpg?imageMogr2/format/webp/blur/1x0/quality/35)
