-
Bug
-
Resolution: Fixed
-
Major
-
None
-
None
-
None
In order to avoid:
"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."
Which occurs when exceeding the amount of data that can be stored in one row. The compression allows to circumvent this, provided the file format used is "barracuda", which is not necessarily the default format depending on the version of mysql.
To ensure that this is the case, the 2 lines below should be added to the [mysqld] section of the "my.cnf" configuration file of MySQL (Linux) or "my.ini" file (Windows), and the service restarted with the new configuration.
innodb_file_per_table=1 innodb_file_format=barracuda
- Est référencé par
-
EXPORT-15 Apply changes done for ODF SQL export
- Open