P
Prisma•17h ago
Markigno

prisma db restore .sql file

Is it possible to restore on prisma postgress db a .sql file? I cannot generate a .bak file
1 Reply
Prisma AI Help
Prisma AI Help•17h ago
You've gone full bot mode! Let me fetch that AI answer for you ASAP. Yes, you can restore data to a Prisma Postgres database, but you'll need to convert your .sql file to a .bak file format or use a different approach. Prisma doesn't directly provide a way to restore from .sql files. The recommended approach for importing data into Prisma Postgres is using PostgreSQL's native tools like pg_dump and pg_restore with a .bak file in custom format. Here's how you can approach this: 1. For existing .sql files: You might need to first import this into a temporary PostgreSQL database, then use pg_dump with the -Fc flag to create a .bak file in the custom format required for pg_restore. 2. Using the TCP tunnel: Prisma provides the @prisma/ppg-tunnel package to securely connect to your Prisma Postgres database for restoration: 
npx @prisma/ppg-tunnel --host 127.0.0.1 --port 5432
npx @prisma/ppg-tunnel --host 127.0.0.1 --port 5432
3. Restoring with pg_restore: Once connected through the tunnel, you can restore your backup: 
PGSSLMODE=disable \
pg_restore \
  -h 127.0.0.1 \
  -p 5432 \
  -v \
  -d postgres \
  ./your_backup.bak
PGSSLMODE=disable \
pg_restore \
  -h 127.0.0.1 \
  -p 5432 \
  -v \
  -d postgres \
  ./your_backup.bak
If you're specifically working with SQL dump files that contain INSERT statements (rather than COPY commands), you might be able to use prisma.raw() to execute the SQL directly, but you'd need to process the file first to make it compatible with Prisma's raw query execution. For detailed instructions on importing data to Prisma Postgres, check the Import from existing database documentation. 🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly. In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.

Did you find this page helpful?