CODEWITHSUNDEEP
mysqlcompatibilityflyway
Corneliu Maftuleac
Corneliu Maftuleac

Reputation: 448

How to fix breaking changes with flyway?

I have a mysql database. In one of the earliest schema versions there was a script that created a table with a null primary key (yes this was a bug in MySql <= version 5.6)

When upgrading the server to mysql57 the migration stops at this point and cannot continue because of migration script itself is not compatible anymore.

I mean, I cannot fix the migration script schema v3 when we are in v11 now, and it has a checksum also.

How do you handle this kind of situations?

Upvotes: 1

Views: 415

Answers (1)

Stanislav
Stanislav

Reputation: 28106

It seems, that one possible solution is to modify old migration script and then call repair before migration to correct checksums.

Upvotes: 1

Related Questions