Can converting MyISAM to InnoDB cause problems?

I am changing an old MySQL database table which is still in MyISAM. I'd like to change it to InnoDB, but I don't know whether it can cause problems and it's a pretty important table so I don't want to break anything.

So my question: can it cause problems when I convert a MyISAM table to InnoDB?

Yes, it can cause a number of troubles. However, troubles are rare.

There is a list of possible 'troubles' that you might encounter, including possible solutions in a discussion format in the MariaDB knowledge base..

There is another list in a more concise format with bullet points and discussion to be found on Rick James's MySQL documentation site.

Aside from the various possible trade offs and data issues, one important bit of advice is: do not change the tables in the databases mysql, information_schema, or performance_schema. That can cause serious trouble.

StackExchange Database Administrators Q#167842, answer score: 9