Unable to restore on-prem mysql database backup on Mysql Flexi server

Question

Hi Team,

We are planning to move the database from On-Prem Mysql 5.5 to Flexi Mysql Server 5.7. I have taken backup using mysqldump from on-pre mysql Server and trying to restore the database Flexi server. But while restoring the backup i am getting below error.

ERROR 1497 (HY000) at line 25: The mix of handlers in the partitions is not allowed in this version of MySQL.

I have noticed that backup file has a partitioned table which is trying to create on MYIsam storage engine which is getting failed with above error.

Please do let me know, how can be resolve this issue.

Prashant Dave

Answer 1

Hi, anonymous userPrashant-7984 Welcome to Microsoft Q&A, Thanks for posting your question.
As we understand the ask here is you are facing an issue while restoring the backup on Flexi Mysql Server 5.7.
In this case, you will need to create a mysqldmp schema file and substitute TYPE=MyISAM to TYPE=InnoDB in the .sql to create a table and execute it on the destination flexible server and follow it with data migration.
MyISAM engine is not supported in Azure Database for MySQL, Limitations - Azure Database for MySQL - Flexible Server | Microsoft Learn

Regards
Geetha