Change table type from MyISAM to InnoDB

Question

I wonder if I convert some tables from MyISAM to InnoDB, will this lead to data crashes?

I need to convert some tables to InnoDB so that I can use the transaction, but they contain very important data, so I'm not sure if I should do the conversion or not.

Answer 1

When changing the table database engine, a simple and general task that should not cause damage, the only way to ensure that there is no corruption is to create your own backup first.

Answer 2

Of course, there is always a risk of data loss; but overall I would find it pretty low.

When changing the table, MySQL will work with a temporary copy for most operations, including this one. Therefore, if the operation fails, it will not damage your source table.

And having a backup will make you feel better anyway ...

Answer 3

MySQL designed it so that the conversion between table types is reliable.

The only risk for your data, with the exception of the time required for conversion, is the usual background risk that you will have at any time when your database is running. That is, you should always have backups, and if you don’t lose anything, it’s important that you should probably have replication.