Export database from MySQL v5.5 to MySQL 5.7

253 views Asked by At

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';
  1. 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?

  2. Is this the only compatibilty issue that could exist, if so is it safe to just grep these statments?

0

There are 0 answers