AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

RDS: Unable to restore MySQL 5.6 snapshot

0

I have a snapshot of a MySQL 5.6.35 instance that I want to restore, but it seems like this is no longer possible, I just get the following message when trying to restore the snapshot from the AWS console :

RDS does not support creating a DB instance with the following combination: DBInstanceClass=db.m6i.large, Engine=mysql, EngineVersion=5.6.35, LicenseModel=general-public-license. For supported combinations of instance class and database engine version, see the documentation.

Is there any other way to retrieve the database contents from the snapshot? Or is there a way to upgrade the snapshot itself to MySQL 5.7?

주제
마이그레이션 및 현대화분석데이터베이스
태그
아마존 Relational Database ServiceMySQL
언어
English
rePost-User-3880764
질문됨 일 년 전501회 조회
2개 답변
1

Unfortunatly RDS does not support your following configuration, however you could upgrade to MySQL 5.7 (You can use the AWS CLI or SDK to upgrade the snapshot to MySQL 5.7. After upgrading, you can create a new RDS instance with the upgraded snapshot). or upload your snapshot to an EC2 instance (which may take a few more steps)

AWS_Guy
답변함 일 년 전
  • rePost-User-3880764
    일 년 전

    Thanks for the answer, I will give it a go from the CLI then ...

  • rePost-User-3880764
    일 년 전

    Hmm, it doesn't seem to work from the CLI either :

    C:\WINDOWS\system32>aws rds modify-db-snapshot --db-snapshot-identifier mysqldb5635-snapshot --engine-version 5.7.38 --profile dbadmin

    An error occurred (InvalidParameterCombination) when calling the ModifyDBSnapshot operation: You can't upgrade the DB snapshot from the engine version 5.6.35 to 5.7.38.

0
수락된 답변

Ok, seems like in my case the answer was to choose a bigger machine to restore it to, i.e. db.m5.xlarge instead of db.m5.large

rePost-User-3880764
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠