a month ago
sqlite3 /data/oi_engine.db "ALTER TABLE signals ADD COLUMN funding_rate_1h REAL DEFAULT NULL;
How do I run this function
6 Replies
a month ago
You can run that command inside your service container using railway ssh from the Railway CLI, which opens an interactive shell session where you can execute commands directly.
Status changed to Awaiting User Response Railway • about 1 month ago
Status changed to Awaiting Railway Response Railway • about 1 month ago
a month ago
Tell me more about the problem you are having still.
Status changed to Awaiting User Response Railway • about 1 month ago
a month ago
Subject: How to access data stored in a mounted volume
Hi Railway Support,
I have a Python worker service running on Railway with a persistent volume mounted at /data. The service writes to a SQLite database at /data/ppds.db.
I need to access and export this database file directly. My service plan does not include shell/console access.
Could you advise on the best way to:
1. Access files stored in a mounted volume
2. Export or download the SQLite database file
Any guidance would be appreciated.
Thank you
Status changed to Awaiting Railway Response Railway • about 1 month ago
a month 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 1 month ago
a month ago
Hello phankamsi,
since you can't access the shell directly , the workaround is to deploy the filebrowser template into your existing railway project (not a new one), before doing anything make sure to remove the active deployment on your worker first otherwise it may try to write to a non-existent volume, then detach the volume from your worker and attach it to filebrowser, also make sure to set use_volume_root=1 as an env variable on filebrowser so it can see your files at /data, then just open the filebrowser url, log in and download your ppds.db straight from the browser, once done detach from filebrowser reattach to your worker and redeploy. heads up your worker will be down during this so plan for a few minutes of downtime
template here: https://railway.com/deploy/Nan7Bs
hope this help you :)
phankamsi
Subject: How to access data stored in a mounted volume Hi Railway Support, I have a Python worker service running on Railway with a persistent volume mounted at /data. The service writes to a SQLite database at /data/ppds.db. I need to access and export this database file directly. My service plan does not include shell/console access. Could you advise on the best way to: 1\. Access files stored in a mounted volume 2\. Export or download the SQLite database file Any guidance would be appreciated. Thank you
a month ago
(All plans have shell access)
0x5b62656e5d
(All plans have shell access)
a month ago
yes, exactly i was wondering why he said he had no access
