# Schema that Imports in 5.5 Doesn't In 5.6 or 5.7

**URL:** <https://forums.percona.com/t/schema-that-imports-in-5-5-doesnt-in-5-6-or-5-7/4981>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [July 20, 2016, 10:04am UTC](https://forums.percona.com/t/schema-that-imports-in-5-5-doesnt-in-5-6-or-5-7/4981 "2016-07-20T10:04:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![amykhar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@amykhar](https://forums.percona.com/u/amykhar)\
**Post date:** [July 20, 2016, 10:04am UTC](https://forums.percona.com/t/schema-that-imports-in-5-5-doesnt-in-5-6-or-5-7/4981/1 "2016-07-20T10:04:18Z")

</div>

I’m trying to figure out exactly what has changed between version 5.5 and 5.6 that introduced this row size too large error. I’ve tried using both Barracuda and Antelope in 5.7. I’ve tried setting row\_format to dynamic and compressed. Nothing works. I’ve read the documentation and am just not seeing what’s changed that is causing this problem. Yes, I know this table is crazy large, but there’s nothing I can do about that at this time.

Here is the one table that is failing:

CREATE TABLE `form_4_data` (  
`id` int(10) unsigned NOT NULL AUTO\_INCREMENT,  
`instance_id` int(11) NOT NULL,  
`field_225` int(10) DEFAULT NULL,  
`field_227` datetime DEFAULT NULL,  
`field_229` mediumtext,  
`field_231` mediumtext,  
`field_233` mediumtext,  
`field_236` mediumtext,  
`field_237` int(10) DEFAULT NULL,  
`field_239` int(10) DEFAULT NULL,  
`field_241` int(10) DEFAULT NULL,  
`field_243` datetime DEFAULT NULL,  
`field_245` datetime DEFAULT NULL,  
`field_246` mediumtext,  
`field_249` datetime DEFAULT NULL,  
`field_250` mediumtext,  
`field_251` mediumtext,  
`field_252` mediumtext,  
`field_253` mediumtext,  
`field_254` mediumtext,  
`field_255` mediumtext,  
`field_256` mediumtext,  
`field_257` mediumtext,  
`field_260` mediumtext,  
`field_261` mediumtext,  
`field_263` mediumtext,  
`field_264` mediumtext,  
`field_266` mediumtext,  
`field_267` mediumtext,  
`field_269` mediumtext,  
`field_271` mediumtext,  
`field_273` mediumtext,  
`field_276` mediumtext,  
`field_279` mediumtext,  
`field_281` mediumtext,  
`field_283` mediumtext,  
`field_285` mediumtext,  
`field_287` mediumtext,  
`field_289` mediumtext,  
`field_291` mediumtext,  
`field_294` datetime DEFAULT NULL,  
`field_297` mediumtext,  
`field_300` mediumtext,  
`field_301` mediumtext,  
`field_302` mediumtext,  
`field_304` mediumtext,  
`field_305` mediumtext,  
`field_306` mediumtext,  
`field_307` mediumtext,  
`field_308` mediumtext,  
`field_309` mediumtext,  
`field_310` mediumtext,  
`field_311` mediumtext,  
`field_312` mediumtext,  
`field_313` mediumtext,  
`field_314` mediumtext,  
`field_315` mediumtext,  
`field_316` mediumtext,  
`field_317` mediumtext,  
`field_318` mediumtext,  
`field_319` mediumtext,  
`field_320` mediumtext,  
`field_321` mediumtext,  
`field_322` mediumtext,  
`field_323` mediumtext,  
`field_324` mediumtext,  
`field_325` mediumtext,  
`field_326` mediumtext,  
`field_327` mediumtext,  
`field_328` mediumtext,  
`field_329` mediumtext,  
`field_330` mediumtext,  
`field_331` mediumtext,  
`field_332` mediumtext,  
`field_333` mediumtext,  
`field_334` mediumtext,  
`field_335` mediumtext,  
`field_336` mediumtext,  
`field_337` mediumtext,  
`field_338` mediumtext,  
`field_339` mediumtext,  
`field_340` mediumtext,  
`field_341` mediumtext,  
`field_342` mediumtext,  
`field_343` mediumtext,  
`field_344` mediumtext,  
`field_345` mediumtext,  
`field_346` mediumtext,  
`field_347` mediumtext,  
`field_348` mediumtext,  
`field_349` mediumtext,  
`field_350` mediumtext,  
`field_351` mediumtext,  
`field_352` mediumtext,  
`field_353` mediumtext,  
`field_354` mediumtext,  
`field_355` mediumtext,  
`field_356` mediumtext,  
`field_357` mediumtext,  
`field_358` mediumtext,  
`field_359` mediumtext,  
`field_360` mediumtext,  
`field_361` mediumtext,  
`field_362` mediumtext,  
`field_363` mediumtext,  
`field_364` mediumtext,  
`field_365` mediumtext,  
`field_366` mediumtext,  
`field_367` mediumtext,  
`field_368` mediumtext,  
`field_369` mediumtext,  
`field_371` mediumtext,  
`field_372` mediumtext,  
`field_373` datetime DEFAULT NULL,  
`field_374` mediumtext,  
`field_375` mediumtext,  
`field_376` mediumtext,  
`field_377` datetime DEFAULT NULL,  
`field_0` mediumtext,  
`field_379` mediumtext,  
`field_380` mediumtext,  
`field_381` mediumtext,  
`field_383` mediumtext,  
`field_384` mediumtext,  
`field_385` datetime DEFAULT NULL,  
`field_386` mediumtext,  
`field_387` mediumtext,  
`field_389` datetime DEFAULT NULL,  
`field_390` datetime DEFAULT NULL,  
`field_391` mediumtext,  
`field_392` mediumtext,  
`field_394` mediumtext,  
`field_395` mediumtext,  
`field_396` mediumtext,  
`field_397` mediumtext,  
`field_1` mediumtext,  
`field_401` int(10) DEFAULT NULL,  
`field_434` int(10) DEFAULT NULL,  
`field_436` int(10) DEFAULT NULL,  
`field_438` int(10) DEFAULT NULL,  
`field_487` mediumtext,  
`field_492` mediumtext,  
`field_2` mediumtext,  
`field_505` int(10) DEFAULT NULL,  
`field_678` mediumtext,  
`field_681` datetime DEFAULT NULL,  
`field_682` datetime DEFAULT NULL,  
`field_683` datetime DEFAULT NULL,  
`field_684` mediumtext,  
`field_686` mediumtext,  
`field_687` mediumtext,  
`field_688` mediumtext,  
`field_689` mediumtext,  
`field_690` mediumtext,  
`field_694` mediumtext,  
`field_760` mediumtext,  
`field_784` mediumtext,  
`field_786` mediumtext,  
`field_824` mediumtext,  
`field_827` mediumtext,  
`field_828` mediumtext,  
`field_829` mediumtext,  
`field_830` mediumtext,  
`field_853` mediumtext,  
`field_864` mediumtext,  
`field_865` mediumtext,  
`field_868` mediumtext,  
`field_870` mediumtext,  
`field_871` mediumtext,  
`field_872` mediumtext,  
`field_873` mediumtext,  
`field_874` mediumtext,  
`field_875` mediumtext,  
`field_876` mediumtext,  
`field_877` datetime DEFAULT NULL,  
`field_878` mediumtext,  
`field_879` mediumtext,  
`field_880` mediumtext,  
`field_881` mediumtext,  
`field_882` mediumtext,  
`field_883` mediumtext,  
`field_884` mediumtext,  
`field_885` mediumtext,  
`field_886` datetime DEFAULT NULL,  
`field_887` mediumtext,  
`field_888` int(10) DEFAULT NULL,  
`field_889` mediumtext,  
`field_890` mediumtext,  
`field_891` datetime DEFAULT NULL,  
`field_892` mediumtext,  
`field_893` mediumtext,  
`field_894` mediumtext,  
`field_895` mediumtext,  
`field_896` mediumtext,  
`field_897` mediumtext,  
`field_898` mediumtext,  
`field_899` mediumtext,  
`field_900` mediumtext,  
`field_901` mediumtext,  
`field_902` mediumtext,  
`field_903` mediumtext,  
`field_904` mediumtext,  
`field_905` mediumtext,  
`field_948` mediumtext,  
`field_958` mediumtext,  
`field_959` mediumtext,  
`field_970` mediumtext,  
`field_971` mediumtext,  
`field_972` mediumtext,  
`field_973` mediumtext,  
`field_974` mediumtext,  
`field_975` mediumtext,  
`field_976` mediumtext,  
`field_977` mediumtext,  
`field_978` mediumtext,  
`field_979` mediumtext,  
`field_980` mediumtext,  
`field_981` mediumtext,  
`field_982` mediumtext,  
`field_983` mediumtext,  
`field_984` mediumtext,  
`field_985` mediumtext,  
`field_986` mediumtext,  
`field_987` mediumtext,  
`field_988` datetime DEFAULT NULL,  
`field_989` datetime DEFAULT NULL,  
`field_990` mediumtext,  
`field_991` mediumtext,  
`field_992` mediumtext,  
`field_994` mediumtext,  
`field_995` mediumtext,  
`field_996` mediumtext,  
`field_997` mediumtext,  
`field_998` mediumtext,  
`field_1014` mediumtext,  
`field_1015` mediumtext,  
`field_1016` mediumtext,  
`field_1017` mediumtext,  
`field_1018` mediumtext,  
`field_1019` mediumtext,  
`field_1020` mediumtext,  
`field_1021` mediumtext,  
`field_1024` mediumtext,  
`field_1028` mediumtext,  
`field_1029` mediumtext,  
`field_1030` mediumtext,  
`field_1031` mediumtext,  
`field_1032` mediumtext,  
`field_1033` mediumtext,  
`field_1034` mediumtext,  
`field_1035` mediumtext,  
`field_1036` mediumtext,  
`field_1037` mediumtext,  
`field_1038` mediumtext,  
`field_1061` mediumtext,  
`field_1062` mediumtext,  
`field_1063` mediumtext,  
`field_1064` mediumtext,  
`field_1066` mediumtext,  
`field_1067` mediumtext,  
`field_1068` mediumtext,  
`field_1069` mediumtext,  
`field_1070` mediumtext,  
`field_1071` mediumtext,  
`field_1072` mediumtext,  
`field_1073` mediumtext,  
`field_1075` mediumtext,  
`field_1076` mediumtext,  
`field_1078` mediumtext,  
`field_1080` mediumtext,  
`field_1081` mediumtext,  
`field_1082` mediumtext,  
`field_1083` mediumtext,  
`field_1084` mediumtext,  
`field_1085` mediumtext,  
`field_1086` mediumtext,  
PRIMARY KEY (`id`),  
KEY `instance_id` (`instance_id`),  
KEY `field_681` (`field_681`),  
KEY `field_682` (`field_682`),  
KEY `field_683` (`field_683`),  
KEY `field_877` (`field_877`),  
KEY `field_886` (`field_886`),  
KEY `field_888` (`field_888`),  
KEY `field_891` (`field_891`),  
KEY `field_988` (`field_988`),  
KEY `field_989` (`field_989`)  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;