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
preguntada hace 4 meses151 visualizaciones
1 Respuesta
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.

respondido hace 4 meses
profile picture
EXPERTO
revisado hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas