Skip to main content
edited body
Source Link

Solution 1: Add the following to the my.cnf file under [mysqld] section.

innodb_file_per_table=1 innodb_file_format = Barracuda 

ALTER the table to use ROW_FORMAT=COMPRESSED.

ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; 

solution 2 : changed the table storage engine to InnoDBMyISAM

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

Solution 1: Add the following to the my.cnf file under [mysqld] section.

innodb_file_per_table=1 innodb_file_format = Barracuda 

ALTER the table to use ROW_FORMAT=COMPRESSED.

ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; 

solution 2 : changed the table storage engine to InnoDB

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

Solution 1: Add the following to the my.cnf file under [mysqld] section.

innodb_file_per_table=1 innodb_file_format = Barracuda 

ALTER the table to use ROW_FORMAT=COMPRESSED.

ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; 

solution 2 : changed the table storage engine to MyISAM

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

formatted code properly
Source Link
mustaccio
  • 28.8k
  • 24
  • 60
  • 77

Solution 1: Add the following to the my.cnf file under [mysqld][mysqld] section. innodb_file_per_table=1 innodb_file_format = Barracuda ALTER

innodb_file_per_table=1 innodb_file_format = Barracuda 

ALTER the table to use ROW_FORMAT=COMPRESSEDROW_FORMAT=COMPRESSED. ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; 

solution 2 : changed the table storage engine to InnoDB

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

Solution 1: Add the following to the my.cnf file under [mysqld] section. innodb_file_per_table=1 innodb_file_format = Barracuda ALTER the table to use ROW_FORMAT=COMPRESSED. ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

solution 2 : changed the table storage engine to InnoDB

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

Solution 1: Add the following to the my.cnf file under [mysqld] section.

innodb_file_per_table=1 innodb_file_format = Barracuda 

ALTER the table to use ROW_FORMAT=COMPRESSED.

ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; 

solution 2 : changed the table storage engine to InnoDB

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large

Source Link

Solution 1: Add the following to the my.cnf file under [mysqld] section. innodb_file_per_table=1 innodb_file_format = Barracuda ALTER the table to use ROW_FORMAT=COMPRESSED. ALTER TABLE nombre_tabla ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

solution 2 : changed the table storage engine to InnoDB

more details here : https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-size-too-large