What should be considered, what should one pay attention to when transferring data from an old table to a new one?

Question

PHP

Good time community!
There was an old table, but it's time for improvements:
- the structure was redesigned
- we immigrate to InnoDB with MyISAM,
- there are more than 1 million records in the table
Share your experience, tell us how not to shoot off your leg?

Answer 1

wrap the insert in a transaction by disabling autocommit. otherwise - no extreme.

Answer 2

Fuck pounding O_o ... If it's not a secret, then what kind of project is this? And if it's not a pity, then a link ...