2 months ago
If a version of my project is unmounted and i click mount will i be able to restore its backups?
Pinned Solution
2 months ago
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
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
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
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.
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
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?
2 months ago
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