Query Regarding AWS Backup and RDS Transfer

0

Good afternoon, everyone!

I have a question about AWS. I have the daily backups of an RDS stored in my AWS account, and I wanted to retrieve a backup from about 3 days ago and overwrite all the content of an RDS using it without needing to spin up a new instance to transfer the data. I just wanted to transfer the content of a backup or snapshot from one RDS to another existing RDS. Would that be possible?

I wouldn't like to use the DBMS because I don't want to copy directly from the instance in question, and I want the data from 3 days ago that is in one of the backups. However, I don't want to restore this backup to a new RDS but to one that I already have. Would that be possible?

Looking forward to your response.

Paulo
已提問 3 個月前檢視次數 140 次
1 個回答
0

Hi, AFAIK, Restoring a backup from Amazon RDS directly onto an existing RDS instance, effectively overwriting its data with the data from the backup, is not directly supported by AWS RDS. The standard process for restoring an RDS snapshot or backup involves creating a new database instance from the selected snapshot. If looking to revert an RDS instance to a previous state without creating a new instance, you could:

  • Backup the current state of the existing instance.
  • Restore the desired snapshot to a new instance.
  • Rename and replace the existing instance with the new one, adjusting any necessary configurations.

Hope this helps.

已回答 3 個月前
profile picture
專家
已審閱 2 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南