fcomby4
-
Posts
4 -
Joined
-
Last visited
Reputation Activity
-
fcomby4 got a reaction from Marc Stridgen in Failed to upgrade from v4.5.4.2 to 4.7.14
Yep, you are absolutely right, my tables had Redundant/Compact row type, generating and executing these queries helped:
SELECT CONCAT( 'ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '` ', 'ROW_FORMAT=DYNAMIC;' ) AS _alter FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB' AND ROW_FORMAT <> 'DYNAMIC' AND TABLE_NAME NOT IN('SYS_DATAFILES', 'SYS_FOREIGN', 'SYS_FOREIGN_COLS', 'SYS_TABLESPACES', 'SYS_VIRTUAL', 'SYS_ZIP_DICT', 'SYS_ZIP_DICT_COLS'); Thank you @Marc Stridgen and @teraßyte !
-
fcomby4 got a reaction from Randy Calvert in Failed to upgrade from v4.5.4.2 to 4.7.14
Yep, you are absolutely right, my tables had Redundant/Compact row type, generating and executing these queries helped:
SELECT CONCAT( 'ALTER TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '` ', 'ROW_FORMAT=DYNAMIC;' ) AS _alter FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB' AND ROW_FORMAT <> 'DYNAMIC' AND TABLE_NAME NOT IN('SYS_DATAFILES', 'SYS_FOREIGN', 'SYS_FOREIGN_COLS', 'SYS_TABLESPACES', 'SYS_VIRTUAL', 'SYS_ZIP_DICT', 'SYS_ZIP_DICT_COLS'); Thank you @Marc Stridgen and @teraßyte !