Answers for "#1118 - Row size too large (> 8126)"

0

#1118 - 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.

just run the following SQL in your MySQL admin

USE db_name;
ALTER TABLE table_name ENGINE=MYISAM;
Posted by: Guest on November-17-2020
0

Row size too large (> 8126)

innodb_strict_mode = 0
Posted by: Guest on August-19-2021
0

Row size too large (> 8126)

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
Copy to clipboard
Posted by: Guest on August-19-2021

Code answers related to "#1118 - Row size too large (> 8126)"

Browse Popular Code Answers by Language