My old database is deployed using MySQL v5.5, however when I export/dump to data using:
mysqldump -u root -p database_name > database_name.sql
Then import that data into my new database using MySQL v5.7, using:
source database_name.sql;
There are then tables missing. There are hundreds of tables so I can't check the reason for all of them. However, for one of them the reason is:
ROW_FORMAT=FIXED is no longer an option for the InnoDB Storage Engine in v5.7
With the relevant SQL statment from database_name.sql being:
CREATE TABLE IF NOT EXISTS `catalog_product_website` (
`product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
`website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
PRIMARY KEY (`product_id`,`website_id`),
KEY `IDX_CATALOG_PRODUCT_WEBSITE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Catalog Product To Website Linkage Table';
My main question is, is there a way to export/dump the data so that I can know it'll be full compatible with MySQL v5.7?
Is this the only compatibilty issue that could exist, if so is it safe to just grep these statments?