Magento Forum

   
Error 1005 while importing sample-data-1.2.0
 
Bob S
Jr. Member
 
Total Posts:  25
Joined:  2007-11-11
 

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?

MySQL 5.1.30

Thanks for any help.

Bob

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top