Manual Snapshots of RDS Issue (MySQL 8.0.27)

0

Greetings, I've been backing up my RDS MySQL instances from january to april of this year manually (one per month at the last day of it), the version of my servers are 8.0.27 and currently this version is deprecated, I was wondering, is there any way to recover my previous manual snapshots? I upgraded the version in order to be able to restore the snapshots from now on, I tried with the migration option but it demands the latest version (8.0.32). Any ideas to recover my information of previous months? It's quite sad to preserve snapshots that I cannot access in any way. Thanks in advance.

質問済み 1年前327ビュー
1回答
2
承認された回答

The console won't allow you to do this but you should be able to do it via CLI (unless this has changed recently but I can't find anything that suggests it has in my search)

https://docs.aws.amazon.com/cli/latest/reference/rds/restore-db-instance-from-db-snapshot.html

aws rds restore-db-instance-from-db-snapshot \
    --db-instance-identifier new-instance \
    --db-snapshot-identifier deprecated-engine-snapshot \
    --db-instance-class db.instance.class
AWS
Brian_D
回答済み 1年前
profile picture
エキスパート
レビュー済み 4日前
profile picture
エキスパート
レビュー済み 6ヶ月前
  • Awesome, I'm gonna try it in order to restore each one, upgrade every copy, restore them and then take a new snapshot with the latest MySQL engine to be able to access them later.

  • Hey, using your suggested solution I got the following: "An error occurred (InvalidSubnet) when calling the RestoreDBInstanceFromDBSnapshot operation: No default subnet detected in VPC" but motivated by your answer I keep searching a solution and I had just to add in the end of the line "--db-subnet-group my_subnet_group" and that's it. Thank you very much for your help. Hope this helps others with a similar issue like this one. Please add the command I mentioned in order to complete the solution.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ