The migration 0_init could not be found.

[MarkForLoop]

Question

I first pulled the database which already existed. (npx prisma db pull)
after I ran "mkdir -p prisma/migrations/0_init" and "npx prisma migrate diff
--from-empty
--to-schema-datamodel schema.prisma
--script > prisma/migrations/0_init/migration.sql"

This created the migration.sql as follows

after I ran "npx prisma migrate resolve --applied 0_init"

which threw this error

Error: P3017

The migration 0_init could not be found. Please make sure that the migration exists, and that you included the whole name of the directory. (example: "20201207184859_initial_migration")

How to reproduce (optional)

Following the baseline setup process

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

• IDE: VScode
• OS: macOS
• Database: PostgreSQL
• Node.js version: v20.10.0
• Prisma Version: 5.11.0

[d33con]

Try changing the file encoding of the migration.sql file to UTF-8. I followed the baseline setup process exactly and got this error, also using VSCode terminal. After some digging I found this and the command worked for me after I changed the encoding. My migration.sql file was UTF-16 originally.

[taburetkin]

same issue. Tried to start using migrations on an exist project and followed baseline guide like in original question
but changing utf-16 to utf-8 does not help
there should be something else
VSCode
win11
PostgreSQL
Node v22.18.0
Prisma 5.19.0