# Overwriting remote SQLite db with local dump

**URL:** <https://community.fly.io/t/overwriting-remote-sqlite-db-with-local-dump/5159>\
**Category:** Questions / Help\
**Tags:** sqlite, volumes, login-only\
**Created:** [May 13, 2022, 10:06pm UTC](https://community.fly.io/t/overwriting-remote-sqlite-db-with-local-dump/5159 "2022-05-13T22:06:39Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![ignoramous](https://avatars.discourse-cdn.com/v4/letter/i/a9adbd/32.png) [@ignoramous](https://community.fly.io/u/ignoramous)\
**Post date:** [May 25, 2022, 4:09am UTC](https://community.fly.io/t/overwriting-remote-sqlite-db-with-local-dump/5159/9 "2022-05-25T04:09:18Z")

</div>

> [@ross](#):
>
> The nice thing about this approach is it transfers directly between devices without an intermediary like Dropbox.

Clever! Reminds me of [GitHub - superfly/wormhole: Fly.io secure tunnel · GitHub](https://github.com/superfly/wormhole)

> [@ross](#):
>
> Plus, you can use wormhole-william’s Go-based API to write a little script to automate these steps if you’re doing it often.

Btw, `6pn` with `scp` works just as nicely: [How to copy files off a VM - #8 by CabelloMania](https://community.fly.io/t/how-to-copy-files-off-a-vm/1651/8)

---

_[View the full topic](https://community.fly.io/t/overwriting-remote-sqlite-db-with-local-dump/5159)._