How to fix P3003: The format of migrations changed in Prisma

# Check your Prisma version
npx prisma --version

# Check Prisma CLI version
npm list @prisma/client
npm list prisma

# Backup your migration files
cp -r prisma/migrations prisma/migrations_backup_$(date +%Y%m%d)

# Backup your database (example for PostgreSQL)
pg_dump your_database_name > database_backup_$(date +%Y%m%d).sql

# For SQLite
cp your_database.db your_database_backup_$(date +%Y%m%d).db

# 1. Delete the migrations directory
rm -rf prisma/migrations

# 2. Reset your database (WARNING: This will delete all data!)
# For PostgreSQL/MySQL:
npx prisma migrate reset --force

# For SQLite, delete the database file and recreate:
rm dev.db

# 3. Create a new initial migration
npx prisma migrate dev --name init

# 4. If you have seed data, run it
npx prisma db seed

# 1. Create a new migrations directory
mkdir -p prisma/migrations_new

# 2. Generate a new migration from your current schema
npx prisma migrate diff \
  --from-empty \
  --to-schema-datamodel prisma/schema.prisma \
  --script > prisma/migrations_new/$(date +%Y%m%d%H%M%S)_init/migration.sql

# 3. Move the old migrations aside and use the new one
mv prisma/migrations prisma/migrations_old
mv prisma/migrations_new prisma/migrations

# 4. Mark the migration as applied (since your database already has the schema)
npx prisma migrate resolve --applied $(date +%Y%m%d%H%M%S)_init

// package.json - pin exact versions
{
  "dependencies": {
    "@prisma/client": "5.6.0"  // Use exact version, not ^ or ~
  },
  "devDependencies": {
    "prisma": "5.6.0"  // Same exact version
  }
}

# Update lockfile
npm install

# Verify versions are consistent
npx prisma --version

npx prisma migrate dev --create-only

// Example: Read old migration files and rewrite in new format
   import fs from 'fs';
   import path from 'path';

   const migrationsDir = 'prisma/migrations';
   const migrationFiles = fs.readdirSync(migrationsDir);

   migrationFiles.forEach(file => {
     const oldPath = path.join(migrationsDir, file, 'migration.sql');
     const newPath = path.join(migrationsDir, file, 'migration.new.sql');

     if (fs.existsSync(oldPath)) {
       const content = fs.readFileSync(oldPath, 'utf8');
       // Convert content to new format
       const newContent = convertMigrationFormat(content);
       fs.writeFileSync(newPath, newContent);
     }
   });