MySQL Forums
Forum List  »  InnoDB

MyISAM to InnoDB: #1025 - Error on rename of './mm_admin/#sql-4ca7_11209' to './mm_admin/menu' (errno: 121)
Posted by: Fernando Morgenstern
Date: May 19, 2010 10:15AM

Hi,

I'm trying to alter my database to InnoDB that is currently using MyISAM. Most of the tables were correctly converted but some of them are giving me errors. Example:

ALTER TABLE `menu` ENGINE = InnoDB

Returns error:

#1025 - Error on rename of './mm_admin/#sql-4ca7_11209' to './mm_admin/menu' (errno: 121)

I read that this usually happens because of foreign key issues but none of the articles mention about changing table from MyISAM to InnoDB.

Any ideas of why this happens and how to fix it?

Thanks!

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.