Menu
Is it possible to create a new db from a snapshot image without migrating it? I have a snapshot of mysql db that I would like to host temporarily to get back some entries. I only seem to have the options to restore it or migrate it to a different version of sql.
341
Choose Snapshots from the navigation pane. From the Snapshots pane, choose the Shared with Me tab. Select the DB snapshot that was shared. Choose Actions, and then choose Copy Snapshot to copy the snapshot into the same AWS Region and with a KMS key from the target account.
Then, share the newly created snapshot. You can share snapshots across AWS Regions. First share the snapshot, and then copy the snapshot to the same Region in the destination account. Then, copy the snapshot to another Region.
To copy your encrypted snapshot to a different AWS Region, simply select the destination region during the Copy Snapshot operation on the AWS Management Console or via the AWS Command Line Interface. You do not need to do anything differently to gain the benefits of incremental copies.
Amazon RDS DB snapshots and automated backups are stored in S3. You can use the AWS Management Console, the ModifyDBInstance API, or the modify-db-instance command to manage the period of time your automated backups are retained by modifying the RetentionPeriod parameter.
When you restore from a DB snapshot, it will create a new RDS instance and have your mysql db setup in it. You can use the connection string to connect to the db via a mysql client and interact with the data.
Here is a guide on how to restore a db instance from db snapshot.
156
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
