Amazon RDS: Restore snapshot to existing instance
I have created a snapshot of my instance and made some unwanted changes in DB.
Now I want to restore my instance from this snapshot.
When I try to do it - it creates me one more instance, additionally to the one I have.
I specify "DB Instance Identifier" and after that I get two instances with the same ID.
So my question: Is there any way to restore snapshot to existing instance?
Because in other case - new instance is created with differrent endpoint (hostname) and I need to change my configs to access database. Or there is a better way to manage such cases?
Answer
No you can't restore back your existing DB instance to any of the either manual backup or point-in-time snapshot.
The only way you can make use of the manual backup or automated snapshot is to create a new RDS DB instance using that. Once the new DB instance is created, you can change the endpoint of DB in your app / code and delete the old DB instance.
Bottomline : You have to change the config settings in your app. No other option.