Query Regarding AWS Backup and RDS Transfer


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.

1 réponse

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.

répondu il y a 3 mois
profile picture
vérifié il y a 2 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions