Fix the Magento Database import error : Can’t create table ‘api_session.frm’ (errno: 150).

Fix the Magento Database import error : Can't create table 'api_session.frm' (errno: 150).

the problem is caused by having ENGINE=InnoDB in lines for foreign keys.

edit the file and do a find/replace for "ENGINE=InnoDB" to remove them.

Make sure to drop / create the database, so you start afresh and re-import the data. Should all work then.

• Tips Blog
• 10th Feb, 2013
• Comment