How can I stop data loss here?

if you are using db push , use this ! https://www.prisma.io/docs/concepts/components/prisma-migrate/shadow-database or u can use prisma migrate

I am using prisma migrate but it asks me to reset databse

A migration might fail if: • You modify a migration before running it and introduce a syntax error •

You add a mandatory (NOT NULL) column to a table that already has data

• The migration process stopped unexpectedly • The database shut down in the middle of the migration process might number 2 is your issue , you need to add a default value

I think instead of run migration at the beginning you should run

migrate resolve --applied <YOUR MIGRATION>

instead https://www.prisma.io/docs/reference/api-reference/command-reference#examples-11

It seems this question is related to the other question you have asked: https://prisma.slack.com/archives/CA491RJH0/p1663741575614379