Restore Backup MYSQL Instance into another instance
lonasozo
PROOP

a year 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

9 Replies

lonasozo
PROOP

a year ago

f714c2fb-b2a9-48db-b9ea-e4b715a4c0e1


a year 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.


a year ago

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


lonasozo
PROOP

a year 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


a year 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

a year ago

Thank you, it worked pretty fine


a year ago

Thank you Erisa!


a year ago

!s


gilbishkosma
PRO

10 months ago

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


Status changed to Solved brody 11 months ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...