Restore Backups
tumericandcumin
PROOP

2 months ago

If a version of my project is unmounted and i click mount will i be able to restore its backups?

Solved$10 Bounty

Pinned Solution

No, you can't access a SQLite database through a TCP proxy since there's nothing to proxy to.

Assuming your SQLite is stored in a proper volume and not in the ephemeral volume of the container, you'll need to deploy a Filebrowser instance, unmount your volume from your service, and re-mount the volume to Filebrowser. You'll then be able to download the SQLite database from Filebrowser's public URL. Keep in mind your original service will not be able to access the database while the volume is mounted to Filebrowser.

5 Replies

Railway
BOT

2 months ago

Backups are tied to the volume itself, not the mount state, so an unmounted volume retains its backups. Once you re-mount it to a service, you can access and restore those backups from the service's Backups tab. Note that backups can only be restored into the same project and environment, and wiping a volume deletes all its backups. More details are in our backups guide.


Status changed to Awaiting User Response Railway about 2 months ago


tumericandcumin
PROOP

2 months ago

Okay so this is a solution that could have helped in my other thread, or a question that could have been asked. Since you're a bot, I assume you train on these conversations.

My other question is, how do i access my database? It is made to update on the site but I want to download it locally to be able to make changes with the most update information locally before pushing updates


Status changed to Awaiting Railway Response Railway about 2 months ago


Railway
BOT

2 months ago

You can connect to your database locally by setting up a TCP Proxy on your database service, which gives you a public URL and port, then use a standard database client (like psql, mysql, mongosh, etc.) with that public connection string. Alternatively, if you have the Railway CLI installed, you can run railway connect to open an interactive shell to your database directly.


Status changed to Awaiting User Response Railway about 2 months ago


Railway

You can connect to your database locally by setting up a [TCP Proxy](https://docs.railway.com/networking/tcp-proxy) on your database service, which gives you a public URL and port, then use a standard database client (like psql, mysql, mongosh, etc.) with that public connection string. Alternatively, if you have the [Railway CLI](https://docs.railway.com/cli/connect) installed, you can run `railway connect` to open an interactive shell to your database directly.

tumericandcumin
PROOP

2 months ago

My database was made in SQLite, so isnt a TCP proxy impossible?


Status changed to Awaiting Railway Response Railway about 2 months ago


Railway
BOT

2 months ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open Railway about 2 months ago


tumericandcumin

My database was made in SQLite, so isnt a TCP proxy impossible?

No, you can't access a SQLite database through a TCP proxy since there's nothing to proxy to.

Assuming your SQLite is stored in a proper volume and not in the ephemeral volume of the container, you'll need to deploy a Filebrowser instance, unmount your volume from your service, and re-mount the volume to Filebrowser. You'll then be able to download the SQLite database from Filebrowser's public URL. Keep in mind your original service will not be able to access the database while the volume is mounted to Filebrowser.


Status changed to Solved 0x5b62656e5d 16 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...