MySQL Error Number 1005
ERROR 1005 (HY000): Can’t create table ‘./wordpress/#sql-2693_f74e.frm’ (errno: 150)
Jason summarized very good article to track down error reported on his blog.
It helped me , hopefully these tricks will help you as well!!
Post in comment , if it helps to save your day!!