I received the following error while trying to import the sample data:
ERROR 1005 (HY000) at line 1185: Can’t create table ‘xxxxxxxx_importdb.catalog_product_website’ (errno: 1478)
The system admin informed me that the problem was actually at line 1192:
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
He said that InnoDB tables cannot use ROW_FORMAT=FIXED. I removed that option and the sample data did import. Can anyone confirm that removing this option will not create problems in the future?
Thanks for any help.