Restore Backup MYSQL Instance into another instance
lonasozo
PROOP

6 months ago

Hello, I need to get data from a backup of my production MYSql instance without sending in production that backup. It is possibile to just download that backup on my computer?

Thank you

Solved

0 Replies

lonasozo
PROOP

6 months ago

f714c2fb-b2a9-48db-b9ea-e4b715a4c0e1


erisa
HOBBY

6 months ago

Assuming you mean the actual railway backups feature, according to this page when you restore a backup it will restore it to a new volume and the old volume will remain intact just unmounted. Since that change is only staged by the restore button, you should be able to swap the mounts back around again before committing the change and attach the restored volume to something else that allows you export the data? For MySQL you can attach it to another service running MySQL and connect to it to export data.


erisa
HOBBY

6 months ago

(I don't have access to this feature to check so its all a guess based off docs)


lonasozo
PROOP

6 months ago

thank you, I mean this function. If I click on restore I get the windows about "Are you sure you want to restore?" attached. I can't restore the database in production, it would be a problem for us.

1378371891710001200
1378371892192219100


brody
EMPLOYEE

6 months ago

Erisa could not be more correct here, I've done it the way they are describing a few times, so please follow their instructions.


lonasozo
PROOP

6 months ago

Thank you, it worked pretty fine


brody
EMPLOYEE

6 months ago

Thank you Erisa!


brody
EMPLOYEE

6 months ago

!s


gilbishkosma
PRO

6 months ago

what's the instruction to attach the restored volumne to the service running MySQL?


Status changed to Solved brody 6 months ago


Loading...