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.