MySQL Forums
Forum List  »  PostgreSQL

Migration from POSTGRES TO MYSQL Row size too large error in mysql create table query
Posted by: RAJESH UPADHYAYA
Date: September 05, 2018 12:10AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration from POSTGRES TO MYSQL Row size too large error in mysql create table query
1207
September 05, 2018 12:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.