Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
