Resolve MySQL error when changing engine from MyISAM to InnoDB

Question

My database experienced some corruption last week, and the technicians from the web hosting company changed all my tables to MyISAM and performed repair on those tables.

However, my application requires InnoDB tables. I've tried the method mentioned in this website However, I get this message

#1025 - Error on rename of './user_db/#sql-689d_6e416' to './user_db/api_role' (errno: 121)

What should I do to resolve the problem?

Answer 1

There's an article here which explains the error code you're seeing.