While restoring database any issue comes like as below

ERROR 1005 at line 51: Can't create table './admin_test/account.frm' (errno: 150)


add the following line in the dump file
SET FOREIGN_KEY_CHECKS = 0;

in the top and try once again.