Magento: Category Flat Data reindex

 The reason for this issue is because the dabase migration cross over the server, the index was changed during the migration. 

ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;

Note: I have used this for Magento ver. 1.7.0.2 its work me.