.::: Get backup Error ERROR 1118 (42000) at line 52172: Row size too large (> 8126) BLOB prefix of 768 bytes :::.

 

1. log as alonge backup

ERROR 1118 (42000) at line 52172: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
 
2. action
MariaDB [(none)]>  SHOW  variables LIKE '%strict%';


MariaDB [(none)]> SET GLOBAL innodb_strict_mode=OFF;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]>

or

[mysqld]

innodb_log_file_size = 512M

innodb_strict_mode = 0

3. set again
MariaDB [(none)]> SET GLOBAL innodb_strict_mode=ON;
Query OK, 0 rows affected (0.001 sec)

 

4. backup again