a month ago
Hello Railway Community,
I’m maintaining a web application on Railway and would appreciate some guidance on a database persistence question.
The application currently uses SQLite, and I want to ensure its existing data is safely preserved when moving from container-local storage to a persistent volume.
I’m looking for recommendations on:
- Creating a consistent backup of a SQLite database before making infrastructure changes.
-
- Safely transferring existing data to a persistent volume without losing records.
-
- Verifying database integrity before and after migration.
-
- Configuring the application to use the persistent database path correctly.
-
- Testing persistence and recovery before considering the migration complete.
I currently manage the project from an Android phone and do not have access to a local computer or terminal. Is there a Railway-supported, browser-based approach for carrying out these steps safely?
I would appreciate any recommended documentation, tools, or migration procedures.
Thank you!
Pinned Solution
a month ago
You’ll need a Pro plan to be able to use volume backups on Railway.
To migrate your SQLite database, right click on your service to mount a volume, then after deploying, go to the Console tab of your service, and in the filebrowser, navigate to the mount path of the volume, and upload the file directly into the directory.
5 Replies
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 1 month ago
a month ago
You’ll need a Pro plan to be able to use volume backups on Railway.
To migrate your SQLite database, right click on your service to mount a volume, then after deploying, go to the Console tab of your service, and in the filebrowser, navigate to the mount path of the volume, and upload the file directly into the directory.
0x5b62656e5d
You’ll need a Pro plan to be able to use volume backups on Railway. To migrate your SQLite database, right click on your service to mount a volume, then after deploying, go to the Console tab of your service, and in the filebrowser, navigate to the mount path of the volume, and upload the file directly into the directory.
a month ago
Thank you very much for the response, I am currently on a Hobby Plan, Will it work?
0x5b62656e5d
Will the database work? Yes. Will backups work? No.
a month ago
Okay thank you, I'll try it now, to be honest it's been frustrating trying to figure this out 🙏🙏🙏🙏
0x5b62656e5d
You’ll need a Pro plan to be able to use volume backups on Railway. To migrate your SQLite database, right click on your service to mount a volume, then after deploying, go to the Console tab of your service, and in the filebrowser, navigate to the mount path of the volume, and upload the file directly into the directory.
a month ago
Thank you very much for your guidance! Your explanation helped me find a practical way forward using the Railway Console on my phone. I appreciate your assistance and will mark your response as the accepted solution. 🙏
Status changed to Solved 0x5b62656e5d • about 1 month ago
