Flyway migrate says schema is up to date

Question

I have installed Flyway in my server and trying to execute a My-sql file which I placed in sql folder of flyway.

I have done Flyway baseline, and when I run flyway migrate it says "Schema xyz is up to date. No migration necessary." No matter what I do it always gives me the same result.

My sql files are named 1__act.sql, 2__act.sql, 3__act.sql.

My config file has

flyway.url=jdbc:mysql://mysql:port/xyz
flyway.user=flywayuser
flyway.password=flywaypassword
flyway.baselineVersion=1

Answer 1

You haven't followed the naming conventions for Versioned SQL migrations, they should be prefixed with a V. e.g. V1__act.sql.

Note that the prefix is configurable, but above is the default.