19 days ago
Hello,
My MySQL service is stuck in an Out Of Memory loop and cannot boot even after increasing memory to 8GB.
I do not have a backup and I really need to recover my data.
Is it possible to export or access the database volume or snapshot?
The service is still active, but it crashes immediately on startup.
Project name: Web Proje
Service: MySQL
Region: us-west2
This is urgent for me. I would really appreciate any help.
Thank you.
1 Replies
Status changed to Open Railway • 19 days ago
19 days ago
Hey, if you want to export the data, you can do it by following these steps:
1. Go to your database settings and find the startup command.
2. Change the startup command to be sleep 10000000;.
3. Install the Railway CLI and link your service.
4. Type railway ssh and import your SSH key.
5. After that, go to your database, hit CTRL + K and select "Copy Service Instance ID".
6. Then, using scp -r <service-instance-id>@ssh.railway.com:/path/to/data . you can export your data.
But it's really strange that you are getting OOMs. Are you new to the Hobby Plan? Or were you running heavy queries on your MySQL database? I would recommend looking at fixing the issue first before proceeding on exporting the data, and I can help you with that, logs are appreciated, same with screenshots of the service volume and metrics page.