# Best way to import data (not ddl) from Google Cloud SQL into Fly.io Postgres

**URL:** <https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432>\
**Category:** Questions / Help\
**Tags:** postgres, login-only\
**Created:** [November 3, 2022, 5:51pm UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432 "2022-11-03T17:51:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![danielyogel](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/danielyogel/32/6332_2.png) [@danielyogel](https://community.fly.io/u/danielyogel)\
**Post date:** [November 3, 2022, 5:51pm UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432/1 "2022-11-03T17:51:22Z")

</div>

Hi,

What is the best way (or ways) to import data from an existing Google Cloud SQL Postgres instance?  
All relevant tables already exist in my Fly’s Postgres app, so no need to run create table and similar statements.

Thank you.

---

<div class="post-metadata">

**Author:** ![lubien](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/lubien/32/41919_2.png) [@lubien](https://community.fly.io/u/lubien)\
**Post date:** [November 3, 2022, 6:26pm UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432/2 "2022-11-03T18:26:29Z")

</div>

I think this post might help you:

> [@Transferring Postgres from Heroku](https://community.fly.io/t/transferring-postgres-from-heroku/6611/14):
>
> Wuhu tada it finally worked for me. Thank you so much @tj1 for leading me on the way. Here is a precise breakdown of what I did for it to work, with a lot of repetition from @tj1 's advice: Get your latest dump by running heroku login heroku pg:backups:capture heroku pg:backups:download In one terminal, launch: fly proxy 15432:5432 -a my-db-app-name # make sure it's the name of your db-app, not your main app In another terminal, list your db names to get the exact name of your DB with…

---

<div class="post-metadata">

**Author:** ![catflydotio](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/catflydotio/32/14559_2.png) [@catflydotio](https://community.fly.io/u/catflydotio)\
**Post date:** [April 27, 2024, 12:15am UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432/3 "2024-04-27T00:15:32Z")

</div>

Category updated on April 27, 2024, 12:15am UTC

From #How To to #Questions / Help

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/fly1/original/3X/6/e/6e8955d00cb218e186ebbe3a6ab06fefdce15290.svg) [@system](https://community.fly.io/u/system)\
**Post date:** [May 4, 2024, 12:15am UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432/4 "2024-05-04T00:15:36Z")

</div>

Closed on May 4, 2024, 12:15am UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.