Migration from POSTGRES TO MYSQL Row size too large error in mysql create table query

[RAJESH UPADHYAYA]

Hi all,

While migrating from postgres to mysql via MYSQL WORKBENCH. I am getting this error with several tables.


Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.
SQL Error: 1118
- Creating table local.name_datadictionary
Execute statement:
CREATE TABLE IF NOT EXISTS `local`.`name_datadictionary` (
`id` INT NOT NULL AUTO_INCREMENT,
`column_name` VARCHAR(255) NULL,
`column_format` VARCHAR(255) NULL,
`column_type` VARCHAR(255) NULL,
`field_name` VARCHAR(255) NULL,
`column_max_length` INT NULL,
`rows_with_data` INT NOT NULL,
`intrinsic_values_count` INT NULL,
`warnings` VARCHAR(1024) NULL,
`actions` VARCHAR(50) NULL,
`sufficiency_test` INT NOT NULL,
`mapping_test` TINYINT NOT NULL,
`format_test` VARCHAR(255) NULL,
`intrinsic_test` VARCHAR(255) NULL,
`datafile_id` INT NOT NULL,
PRIMARY KEY (`id`),
INDEX `name_datadictionary_eb3dffdfc66` (`datafile_id` ASC),
CONSTRAINT `name_datadictionary_datafile_id_c243sdsds5_fk_name_datafiles_id`
FOREIGN KEY (`datafile_id`)
REFERENCES `local`.`name_datafiles` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
- Creating table local.name_datadictionary_intrinsic_values
Execute statement:

Please help me how to fix this..


Thanks and Regards,
Rajesh Upadhyaya