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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则