Re: How can I fix Engine errors after migration from 5.7 to 8

[Henrique Garcia]

Hi Vito, how are you?

MySQL 8.0 still supports MyISAM, but mixing database engines during migration is not recommended.

If some tables need to be InnoDB, convert them explicitly:
ALTER TABLE db.table ENGINE = InnoDB;

Best practice is to convert MyISAM → InnoDB in MySQL 5.7 before dumping, running mysqldump, and restoring the database in MySQL 8.0.

After importing, check the database engines and errors before restarting the server.

If necessary, start MySQL 8.0 with a clean data directory and re-import the data instead of modifying the tables during restoration.

Best regards,
Henrique Garcia